Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please give me solution for this,
I need Sequence number based on the category for selected date.
For Example,
Date ID Category
1/1/2016 1 connect
1/1/2016 2 connect
1/1/2016 3 connect
1/1/2016 1 Disconnect
1/1/2016 2 Disconnect
1/1/2016 3 Dicconnect
1/1/2016 1 close
1/1/2016 2 close
2/1/2016 1 connect
2/1/2016 2 connect
2/1/2016 3 connect
2/1/2016 1 Disconnect
2/1/2016 2 Disconnect
2/1/2016 3 Dicconnect
2/1/2016 1 close
2/1/2016 2 close
Thanks,
Lawrance. A
Probably need peek and order by :