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 the most common sql injection tool?

543


What is parallel hint?

746


What are the advantages of indexing?

519


Can we use ddl statements in stored procedure sql server?

514


how to create a new view in mysql? : Sql dba

492






What is the difference among union, minus and intersect?

544


What are the types of variables use in pl sql?

501


What plvcmt and plvrb does in pl/sql?

874


Why are indexes and views important to an organization?

525


What is sharding in sql?

562


What is a join?

621


How do I view a view in sql?

504


What is the difference between inner join and outer join?

526


Can cursors be part of a trigger body?

1112


What are types of exception?

532