select salary from tablename t1 where n=(select count(*)from tablename t2

how to find nth highest salary

Question Posted / elumalai.k

Answer Posted / elumalai.k

select salary from tablename t1
where n=(select count(*)from tablename t2
where t1.salary<=t2.salary)

Is This Answer Correct ?

16 Yes

16 No

Please Help Members By Posting Answers For Below Questions

List the different normalization forms?

986

What is the difference between sdf and mdf?

1305

What is report rendering ?

162

When would you use sql joins?

966

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1058

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

994

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

127

Is it possible for a stored procedure to call itself or recursive stored procedure?

952

What is history table in sql server?

978

How to send email from database?

1018

What are clustered and non-clustered index?

1012

What is 5nf in normalization form?

1001

What do you mean by the term 'normalization'?

1217

What do you understand by a view?

1005

What is the difference between update lock and exclusive lock?

983