Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
zturaiki
Contributor III
Contributor III

autonumber

this is my original data

Original Data

IdDate
A15/12/13 12:00 AM
A15/13/13 12:00 AM
A15/14/13 12:00 AM
A15/15/13 12:00 AM
B25/16/13 12:00 AM
B25/17/13 12:00 AM
C45/18/13 12:00 AM
C45/19/13 12:00 AM
C45/20/13 12:00 AM
D55/21/13 12:00 AM
E65/22/13 12:00 AM

I want That
  Result From Above

IdDateRow No
A15/12/13 12:00 AM1
A15/13/13 12:00 AM2
A15/14/13 12:00 AM3
A15/15/13 12:00 AM4
B25/16/13 12:00 AM1
B25/17/13 12:00 AM2
C45/18/13 12:00 AM1
C45/19/13 12:00 AM2
C45/20/13 12:00 AM3
D55/21/13 12:00 AM1
E65/22/13 12:00 AM1
14 Replies
zturaiki
Contributor III
Contributor III
Author

it take more time

Not applicable

Use Rownum ()

its very common to use auto genrate numbers.

Regards

Asim

sunilkumarqv
Specialist II
Specialist II

Good work done by  VISHWARANJAN  and

to Zainab make order by date in your script table things done easy.

Anonymous
Not applicable

Load

     field1,

     field2,

     Rowno() As Rowno

From yourtable;

anant

Not applicable

Hi Vishwa,

Could please let know for the above mentioned data and one more request(while loading the data from excel how to do the same).

Regards,

Rajesh