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
What are the different types of locks in the database?
Explain datetime2 data type in sal server 2008?
Using the customer, and order table in northwind database, please write a query to produce xml?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
how to define testing of network layers? : Sql server database administration
What is tcl in sql server?
Explain what is the difference between a local and a global temporary table?
How can I add Reporting Services reports to my application?
Do you know how to implement service broker?
What is a primary index?
What is the difference between dataadapter and datareader?
What is the difference between a "where" clause and a "having" clause?
How to change the data type of an existing column with "alter table" statements in ms sql server?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What are the differences between decimal and float in ms sql server?