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
What are different categories of sql commands?
tell me about various levels of constraint. : Sql dba
Why is %isopen always false for an implicit cursor?
What operating systems are supported by oracle sql developer?
What is the clause we need to add in function body to return variable?
What is trigger in pl sql with examples?
What is sql performance tuning?
Is hadoop a nosql?
How many subqueries can be nested in a statement?
Why do we need databases?
Which is better join or subquery?
How to start oracle sql developer?
What is view? Can we update view
Is ms sql traffic encrypted?
how many sql ddl commands are supported by 'mysql'? : Sql dba