SQL Help Needed

[Rossmac]

Hi there

Just looking for some basic help in MS SQL.

Is there any way to select only the 2nd row from a table?

ie. SELECT ROW 2 * FROM table

any suggestions?

Many thanks,
Ross

 

[Rossmac]

Why would ya want to do this!!!!!!

Oh, and not sure about MS SQL but if it is the same as MySQL:

SELECT * FROM `your_table` LIMIT 2, 1

Pretty much I have got a table with 3 values in it.

I need the value from the 2nd row.

I'll try that or variations now.

Many thanks,
Ross

 

[Rossmac]

Use an auto-incrementing (<-- spelling) ID field.

SELECT * FROM table WHERE id = 2

Yip would love to, however I am not able to add a field to the table as it would require testing of hundreds of other stored procedures... which I'm not prepared to do.

I'm using Transact-SQL I found out, if that is off any use to anyone.