| displaying serial no. [message #272061] |
Wed, 03 October 2007 22:08  |
alister
Messages: 101
Registered: August 2007
Location: India
|
Senior Member |
|
|
I want to display the serial no for each row in a report. It's just a running number. For example
Select empno,empname from empmast;
If there are 100 records I want a serial no before empno, from 1 to 100. Can anyone tell me how to do this.
Alister
|
|
|
|
| Re: displaying serial no. [message #272087 is a reply to message #272061] |
Thu, 04 October 2007 00:29  |
 |
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
It's been answered several times in the past few weeks. Use the Search facility of the OraFAQ Forum to find these topics.
Also, read the OraFAQ Forum Guide to avoid such answers (especially "How to get a quick answer to your question?" section).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
