Db2 query : equivalent function for partion by as in oracle

l.nethaji · New User Joined: 16 Mar 2008 Posts: 4 Location: tamil nadu

i want to generate a seq_no at pol_id level
for example

The output should look like the below resultant set

ownerid polid seq_no
a1 123 1
a1 234 2
a1 345 3
a2 001 1
a2 765 2
a3 233 1
a4 444 1

whether we can go with the below query .

Select ownerid, poled, row_number() over (partition by ownerid order by polid asc) as seq_no

whether DB2 supports partition by function

Please let me know if u have any solution to this scenario.

Thanks
L.Nethaji

the_gautam · Posted: Sat May 10, 2008 6:40 am Post subject:

what is your table structure?