Thread: Row Number Each Group
View Single Post
  #1 (permalink)  
Old 07-02-2008, 03:50 PM
Jeremias Spoken Jeremias Spoken is offline
Junior Member
  
Join Date: Jun 2008
Posts: 5
Jeremias Spoken is on a distinguished road
Default ANY dialect question:

Row Number Each Group

Hi...!

To a similar table I need to add a row number...

Code:
GRP          RowNR
73463          1
73463          2
73463          3
73463          4
53246          1
53246          2
78843          1
43543          1
43543          2
43543          3
43543          4
43543          5
Please don't tell me that use Temp Tables, if it's possible only T-SQL... I use DB2 over ISeries...

With ROW_NUMBER() OVER() is like a sequence but doesn't work for each group...

Thanks in advance and regards...!
Reply With Quote

ANSWER(S):