Numbering the records 2

[Andrzejek]

If I have some simple SQL like:

Select FName, LName, Office from MyTable Where Office = 'Mgmt'

and I get the records:
[tt]
FName LName Office
Bob Brown Mgmt
Susie Smith Mgmt
Joe Horse Mgmt[/tt]

How would my Select look like if I want to add a column to number the records:

[tt]
Line_No FName LName Office
1 Bob Brown Mgmt
2 Susie Smith Mgmt
3 Joe Horse Mgmt[/tt]

???

Have fun.

---- Andy

 

[SantaMufasa]

Select rownum,FName, LName, Office from MyTable Where Office = 'Mgmt'

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[SantaMufasa]

Sorry, you wanted the column to have the name "Line_no", so the code would read:

Select rownum line_no,FName, LName, Office from MyTable Where Office = 'Mgmt'

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[Beilstwh]

and if you wanted to order them

Select rownum line_no,FName, LName, Office
from
(select FName, LName, Office 
 from MyTable 
 Where Office = 'Mgmt' 
 order by Office,LName,FName)

Bill
Lead Application Developer
New York State, USA