Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sam_varg007
Starting Member
8 Posts |
 Posted - 2002-03-06 : 12:56:30
|
| I have a table employee with empname empsal as fields when I select from the table I need to get output as below.SLNO. Name Sal1 SAM 50002 MARK 50003 PHIL 20004 STEVE 30005 MIKE 1000how will I get the SLNO. I don't want to use any identity coloumn or temperory table. Can I get the output in single select statment. ThanksSam |
|
|
Jay99
468 Posts |
|
|
|
|
|
Selecting number