Thanks Tom.. Still i want to ask, should lag function should use same que? i mean this is more meaningfull isnt it? I come across with this problem while i was searching equivalent of oracle partitioned analytic query ( row_number over (partition by a order by b asc) ) Is there a anoher way to do this?
... View more
