how to retrive only second row from table in sql server
2000?
- 15 Answers
- 27371 Views
- Cognizant, CTS, I also Faced
- E-Mail Answers
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 is clustered index
do you know how to configure db2 side of the application? : Sql server database administration
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Why use identity in sql server?
What are the source of constraints?
Can sql servers link to other servers like oracle?
Is it possible to have clustered index on separate drive from original table location?
How do I find query history in sql server?
How do I create a trace in sql server?
Can you index views?
What are the kinds of subquery?
what is the difference between openrowset and openquery?
What is a view in sql?
How do I start sql server 2017?
Why and when do stored procedure recompile?
