select `salary` from test t1 where 0=(select count(*) from test where t1.`

how to find nth highest salary

Question Posted / harninder

Answer Posted / harninder

select `salary` from test t1 where 0=(select count(*) from
test where t1.`salary`<`salary`)

Is This Answer Correct ?

5 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is database replication? What are the different types of replication you can set up in sql server?

964

What are the differences between ms sql server & oracle?

1067

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183

How to create a view on an existing table in ms sql server?

1135

What will be the maximum number of index per table?

1012

How to filter out duplications in the returning rows in ms sql server?

1143

Write a sql query to sort on different column name according to the parameters passed in the function?

911

How you can add messages to the nt event log from within a stored procedure?

1072

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1403

Can you explain important index characteristics?

995

Can we hide the definition of a stored procedure from a use?

1229

How to generate create procedure script on an existing stored procedure?

1014

Explain the disadvantages of cursors?

1146

what is a join? : Sql server database administration

1255

How to query multiple tables jointly?

995