how to find nth highest salary

Question Posted / mnggupta

103 Answers
179646 Views
Cognizant, IBM, NexGen, Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to find nth highest salary..

Answer / haribabuboddapati

select max(sal)*from emp
where sal>select max(sal)*from emp

Is This Answer Correct ?

24 Yes

100 No

how to find nth highest salary..

Answer / rajendra prasad reddy penumall

select salary=max(salart)from from EmpMaster

Is This Answer Correct ?

17 Yes

182 No

how to find nth highest salary..

Answer / rajendra prasad reddy penumall

select salary=max(salart)from from EmpMaster

Is This Answer Correct ?

20 Yes

206 No

Post New Answer

More SQL Server Interview Questions

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers

How many types of local tables are there in sql server?

0 Answers

What is query processing?

0 Answers

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers Fidelity,

List all types of constraints in sql server?

0 Answers

What is the difference between cross join and Full outer join?

1 Answers HP, Standard Bank,

When would you use sql joins?

0 Answers

What are data files?

0 Answers

Is port 1433 secure?

0 Answers

Explain sql server authentication modes?