Get records with serial no in sql server 2000

Question

1.00/5 (1 vote)

See more:

SQL-server-2000

Hi frndz
i want to show data with serial no in sql server 2000..is there are any query in which records are show with serial no meanse 1 2 3 4 5 6...

for eg

ADM-1177 1
ADM-1178 2
ADM-1179 3
ADM-1180 4
ADM-1181 5
ADM-1182 6
ADM-1183 7
ADM-1184 8
ADM-1185 9

i need this serial no 1 2 3 4 5...

Posted 16-Jan-12 22:43pm

puneetisonfire89

Add a Solution

5 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

amolpatil2243 · Answer 1 · 2012-01-16T22:47:00

Solution 1

you can use ORDER BY clause
<pre lang="SQL">
SELECT * FROM tablename ORDER BY serialno</pre>

Posted 16-Jan-12 22:47pm

amolpatil2243

thatraja · Answer 2 · 2012-01-16T22:56:00

Solution 2

Use ROW_NUMBER()
Create a Serial Number Column using SQL Server Query[^]

Posted 16-Jan-12 22:56pm

thatraja

Rockstar_ · Answer 3 · 2012-01-16T23:49:00

Solution 4

Hi friend,

add one more column named serial No. and make it identity column.

Posted 16-Jan-12 23:49pm

Rockstar_

puneetisonfire89 · Answer 4 · 2012-01-16T23:38:00

Solution 3

both r not working in sql 2000

Posted 16-Jan-12 23:38pm

puneetisonfire89

puneetisonfire89 · Answer 5 · 2012-01-17T01:52:00

Solution 5

yeah, bt i already take identity column bt if i want the records with 'WHERE' clause then it dnt show sequence

Posted 17-Jan-12 1:52am

puneetisonfire89

Get records with serial no in sql server 2000

5 solutions

Solution 1

Solution 2

Solution 4

Solution 3

Solution 5

Add your solution here

Preview 0

Get records with serial no in sql server 2000

5 solutions

Solution 1

Solution 2

Solution 4

Solution 3

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us