SELECT EmpID,Salary from tblSalary a where 3=(select count (EmpID) from tb

select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal.

Question Posted / sunil nair

8 Answers
12524 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / sunil nair

SELECT EmpID,Salary from tblSalary a where 3=(select count
(EmpID) from tblSalary b where b.empid=a.empid)

for any RDBMS

Is This Answer Correct ?

2 Yes

13 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why should you use or avoid select * statements?

1002

What is the need for indexing?

927

What are .mdf files?

922

Can a function call a stored procedure in sql server?

939

How to make a column nullable?

1092

Some queries related to SQL

963

Can truncate be rolled back?

918

What are a scheduled jobs?

943

What is openxml in sql server?

1154

How to change the password of a login name in ms sql server?

999

What is merge statement?

1067

Explain alternate key, candidate key and composite key in sql server?

895

What is update locks?

869

How would you go about developing a ssrs report?

166

What are the advantages of sql stored procedure?

1052