SQLServerCentral » Latest topics
Compare two columns
Hi guys,
need quantity from previous row , when prev_orderid=orderid from previous row.
for ex:
If prev_orderid=44086564 matches orderid = 44086564 then i need to select qty as 1900.
please see sql below:
c
need quantity from previous row , when prev_orderid=orderid from previous row.
for ex:
If prev_orderid=44086564 matches orderid = 44086564 then i need to select qty as 1900.
please see sql below:
c
No comments:
Post a Comment