how to check the 3rd max salary from an employee table?
Answer Posted / amit
select max(sal) from emp where sal<(select max(sal) from emp where sal<(select max(sal) from emp));
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is pls_integer in pl sql?
Explain two easy sql optimizations.
Which is better join or subquery?
What are the qualities of 2nf?
What is write ahead logging in sql server?
What are joins in sql?
How to test for null values?
define join and explain different type of joins? : Sql dba
how to concatenate two character strings? : Sql dba
What are the different operators available in sql?
How is a PL/SQL code compiled?
what is 'mysqlcheck'? : Sql dba
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is difference between pls_integer and integer?
What is an invalid partition table?