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 is materialized view in sql?
Is hadoop a nosql?
What sql does db2 use?
How does a trigger work?
What is the command used to fetch the first 5 characters of a string?
Is vs as in pl sql?
How do you sort in sql?
Can we create foreign key without primary key?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What are some emotional triggers?
What operating systems are supported by oracle sql developer?
How to execute a stored procedure?
What are the differences between implicit and explicit cursors?
what is data control language? : Sql dba
Which is better cte or subquery?