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
Define magic tables in sql server?
What is scrollable cursor?
What is database replication? What are the different types of replication you can set up in sql server?
What is the maximum row of a size?
What is #temp and @table variable in SQL server?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
How does recursive cte works in sql server?
Tell me what is the significance of null value and why should we avoid permitting null values?
How to create a local temporary stored procedure?
How to stop log file growing too big?
Do you know what are the reporting services components?
Tell me the phases a transaction has to undergo?
What are the general features of sql server management studio? : sql server management studio
Define inner join in sql server joins?
What is encryption key?