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 drillthrough reports?
What is the main purpose of having conversation group?
What is read committed?
How to enter binary string literals in ms sql server?
What is the tcp/ip port on which sql server runs?
How do I perform an unattended install of sql server 2000?
What type of locking occurs during the snapshot generation? : sql server replication
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is the sql case statement used for? Explain with an example?
What is the command used to check locks in microsoft sql server?
Explain relational data?
How do I create a stored procedure in dbml?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
Do you know concepts and capabilities of sql server?
What are diverse clauses that form a part of sql?