Home » RDBMS Server » Server Administration » How can i make a running number in a View Table
How can i make a running number in a View Table [message #375128] |
Mon, 30 July 2001 02:19 |
Mustafa Sevik
Messages: 3 Registered: July 2001
|
Junior Member |
|
|
Hallo ,
I need a running number in a View grouped by a special field like this example.
Special_Field ,name, Emp_Id, Running_Number
AIF, John, 123, 1
AIF, Peter, 134, 2
AIF, Jenifer, 141, 3
BWH, Bill, 099, 1
BWH, Michael, 103, 2
BWH, Mustafa, 456, 3
BWH, Dirk, 500, 4
CKR, Mary, 025, 1
KRU, Fred, 031, 1
and so on
order by special_Field, Emp_ID
|
|
|
Goto Forum:
Current Time: Tue Dec 24 06:51:12 CST 2024
|