Last post Aug 04, 2017 01:19 AM by Deepak Panchal
Aug 03, 2017 07:31 AM|JagjitSingh|LINK
How ro generate automatic serial no Group wise and for only visible rows. No should restart on change of Group
Aug 04, 2017 01:19 AM|Deepak Panchal|LINK
please refer example below.
I try to create table with only Group_name field.
then I insert some group names.
then I fire query below.
Sr_no = ROW_NUMBER() OVER(PARTITION BY Gorup_name ORDER BY Gorup_name),
Group_id = DENSE_RANK() OVER (ORDER BY Gorup_name)