Link to home
Start Free TrialLog in
Avatar of emi_sastra
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.
SELECT   Nomor_SJ,  ROW_NUMBER() OVER (ORDER BY Nomor_SJ) AS Row,  ProdukCode
FROM         TDSJPOJUAL2009

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of emi_sastra
emi_sastra

ASKER

Hi All,

It works. I combine both query from you to get result.

Thank you very much for your help.

Welcome..