how to retrive only second row from table in sql server
2000?
Answer Posted / lekhraj
select top 1 * from(select top 2 * from tbl_test order by 1
asc) as at order by 1 desc
Is This Answer Correct ? | 24 Yes | 5 No |
Post New Answer View All Answers
explain different types of constraints? : Sql server database administration
Does sql server use t sql?
How to override dml statements with triggers?
Write query to return all rows sql?
What is row_number()?
Mention the 3 ways to get a count of the number of records in a table.
what are isolation levels? : Sql server database administration
List the advantages of using stored procedures?
What is sql profiler. What are the default templates with it? : sql server database administration
What are the five characteristics of good data?
What are the methods used to protect against sql injection attack?
What is report snapshot in ssrs?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What are the authentication modes in sql server? How can it be changed?
How to create an multi-statement table-valued function?