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

How will you monitor replication latency in transactional replication? : sql server replication

1212

What is ms sql server triggers?

1074

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1121

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1074

Explain having clause?

1030

What were the latest updates to SQL Azure service?

113

Explain different types of collation sensitivity?

1032

How do you size a resultset?

970

do you know how to configure db2 side of the application? : Sql server database administration

1101

Do you know how to send email from database?

1049

How to execute a sql statement using odbc_exec()?

1221

Do you know what is bit data type and whats the information that can be stored inside a bit column?

1001

What is join query?

938

What is the current pricing model of SQL Azure?

104

what are the reporting service components in SSRS?

170