DECLARE @SQL VARCHAR(2000), @N INT SET @N = 5 SET @N = @N

how to find nth highest salary

Question Posted / sanchit dubey

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

Answer Posted / sanchit dubey

DECLARE @SQL VARCHAR(2000), @N INT
SET @N = 5
SET @N = @N - 1

SET @sql = 'select top 1 salary from ABC where salary not
in ( SELECT TOP ' + CAST(@n AS VARCHAR(100)) + ' salary
FROM ABC order by salary desc ) ' + ' order by salary desc '

SELECT @SQL
EXEC @SQL

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain triggers?

945

What are the operating modes in which database mirroring runs?

1028

What do you mean by SQL injection attack?

1007

Describe in brief authentication modes in sql server.

968

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

900

What is log ldf?

932

What is a recursive stored procedure in sql server?

1088

What are the different types of join?

1103

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2467

Explain iaas, paas and saas?

Write an sql query for deleting duplicate rows?

955

what are the different stages of Report Processing?

125

What is subquery? Explain the properties of a subquery?

927

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

986

What are the different acid properties?

1014