how to retrive only second row from table in sql server
2000?
Answer Posted / suresh
Hi,
select top 1 * from (SELECT TOP 2 * from emp) A Order by
empno desc
| Is This Answer Correct ? | 16 Yes | 9 No |
Post New Answer View All Answers
What is meant by Active-Passive and Active-Active clustering setup?
How can you manage sql azure security?
How do I port a number to sql server?
How optimize sql query with multiple joins in sql server?
What is a rollup clause?
What are the advantages of policy management?
How to manipulate data from one table to another table ?
What are the new features are introduced in sql server 2012 reporting services?
Sql server reporting services vs. Crystal reports.
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
How do you send email on SQL Server?
How do I run a trace in sql server?
What are binary string data types in ms sql server?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
How can we migrate from SQL server to SQL Azure?