displaying serial no. [message #272061] |
Wed, 03 October 2007 22:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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).
|
|
|