find the third highest salary?

Answer Posted / uday kiran

Its is like Nth highest salary.....


Select * from Employee where salary =
(Select max(Salary) from Employee where salary < (Select max
(Salary) from Employee where
Salary<(Select max(Salary) from Employee where
Salary <…………………………………………… N

Is This Answer Correct ?    15 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is data manipulation language? : Sql dba

702


how to calculate the difference between two dates? : Sql dba

723


What is error ora-01000: maximum open cursors exceeded

783


How is indexing done in search engines?

720


What are the subsets of sql?

754






Why sql query is slow?

729


What is the difference between sum and count in sql?

718


What is the difference between view and stored procedure?

690


tell me about various levels of constraint. : Sql dba

755


Is inner join same as self join?

784


What is trigger and types?

757


What is field delimiter?

793


How do you update f as m and m as f from the below table testtable?

1466


How to select unique records from a table?

762


What is mdb stand for?

733