emi_sastra
asked on
Add Seq Number at Query
Hi All,
I want to add seq no using query and the seq no start from "0001" when Nomor_SJ is different.
How could I do it?
Thank you.
I want to add seq no using query and the seq no start from "0001" when Nomor_SJ is different.
How could I do it?
Thank you.
SELECT Nomor_SJ, ROW_NUMBER() OVER (ORDER BY Nomor_SJ) AS Row, ProdukCode
FROM TDSJPOJUAL2009
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome..
ASKER
It works. I combine both query from you to get result.
Thank you very much for your help.