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 are the 7 disadvantages to a manual system?
Explain about sql server login?
What are the different acid properties?
What is analysis service repository?
Explain linked server in sql?
What new changes are being made in SQL Server?
Why can there be only one clustered index and not more than one?
Explain sql server authentication modes?
What Is Rdbms?
Describe and explain about SQL native client?
Explain the concept of recursive stored procedure.
Would you store your query in a ssrs report or a database server? State the reason why?
What is the difference between a primary key and a unique key? Are they the same?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Can you tell me some of the common replication dmv's and their use? : sql server replication