how to retrive only second row from table in sql server
2000?
Answer Posted / surenda tarai
select top 1 * from(select top 3 * from tablename order by 1
asc) as at order by 1 desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is filestream?
Explain what is cte (common table expression)?
Explain the commands in sql server?
What is the federation in sql azure?
what is raid and what are different types of raid configurations? : Sql server database administration
What is a natural primary key?
What is the temp table?
How many triggers you can have on a table?
What is the report model project?
What type of locking occurs during the snapshot generation? : sql server replication
What does top operator do?
What is user defined datatypes and when you should go for them?
What are the drawbacks of reporting in ssrs?
Where is my database stored on the hard disk in ms sql server?
How do you check sql server is up and running?