-- to find third highest salary from emp table select empname,empsal from

how to find nth highest salary

Question Posted / bala

Answer Posted / bala

-- to find third highest salary from emp table
select empname,empsal from emp a where 3 = (select count(*)
from emp b where a.empsal <= b.empsal);

Is This Answer Correct ?

6 Yes

12 No

Please Help Members By Posting Answers For Below Questions

How to create a login account in ms sql server to access the database engine using "create login" statements?

1146

What is bcp? When does it use?

944

What is a partitioned view?

992

What is a unique key constraint?

1028

What are the features of Embedded SQL

1130

How to insert data into an existing table?

978

what is the difference between count(*) and count(1) ?

1085

Write a query for primary key constraint with identity key word?

1031

Characterize join and name diverse sorts of joins?

968

What is an index in a database?

979

What is dirty read?

1081

Why I have to use stored procedures?

1050

Explain iaas, paas and saas?

How and why use sql server?

1010

How do I view a stored procedure in sql server?

982