how to check the 3rd max salary from an employee table?

Answer Posted / venkateswarulu.s

select min(salary) from emp where salary in(select distinct
top 3 salary from
emp order by salary desc)

Is This Answer Correct ?    13 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different categories of sql commands?

634


tell me about various levels of constraint. : Sql dba

531


Why is %isopen always false for an implicit cursor?

570


What operating systems are supported by oracle sql developer?

520


What is the clause we need to add in function body to return variable?

540






What is trigger in pl sql with examples?

525


What is sql performance tuning?

497


Is hadoop a nosql?

577


How many subqueries can be nested in a statement?

505


Why do we need databases?

567


Which is better join or subquery?

608


How to start oracle sql developer?

558


What is view? Can we update view

867


Is ms sql traffic encrypted?

505


how many sql ddl commands are supported by 'mysql'? : Sql dba

528