SELECT TOP 1 * FROM (SELECT TOP N * FROM EMPSAL ORDER BY ID DESC) A ORDER B

how to find nth highest salary

Question Posted / bhanu prakash

103 Answers
178797 Views
Cognizant, IBM, NexGen, Oracle, I also Faced
E-Mail Answers

Answer Posted / bhanu prakash

SELECT TOP 1 * FROM (SELECT TOP N * FROM EMPSAL ORDER BY ID DESC) A ORDER BY ID

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

965

What is the current limitation of the size of SQL Azure DB?

124

Explain Geometry datatype in sql server 2008 with example

921

Does full backup break log chain?

912

Define self join in sql server joins?

902

Why and when do stored procedure recompile?

931

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1023

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

922

Explain rdbms?

982

How can you append an identity column to a temporary table?

877

Explain magic tables in sql server?

985

What are the benefits of normalization?

1045

Why de-normalization required?

942

How many primary keys are possible in a table?

875

What are diverse clauses that form a part of sql?

1018