l.nethaji
New User
Joined: 16 Mar 2008 Posts: 90 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 |
|