Home » RDBMS Server » Server Administration » running number in a view
running number in a view [message #375113] Fri, 27 July 2001 04:54
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

Report message to a moderator

Previous Topic: Re: Finding a date-format in a string
Next Topic: Migrating SQL-Scripts from 8.0.5.X to 8i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 06:10:42 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.