Answer Posted / moorthy t
select n,* from(select rownum n,* from (select * from table
where group by (sal) order by (sal) desc)) where n=2;
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What happens if null values are involved in datetime operations?
Explain what is use of dbcc commands?
what is a correlated sub-query? : Sql server database administration
What are database states in ms sql server?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
How to download and install sql server 2005 books online?
How you can move data or databases between servers and databases in sql server?
How to add code to the existing article (using improve article)?
List out the differences between global and local temp tables in sql server?
What is delete query?
How to enable/disable indexes?
Does sql server use t sql?
How do I install only the client tools of sql server 2000?
How to verify the port number of the sql server?