how to find the second highest salary from emp table?
Answer Posted / sankar sasmal
select distinct sal from emp e where 2=(select count(distinct sal)from emp s where e.sal<=s.sal)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define union, minus, union all, intersect ?
How can we find duplicate records in a table?
Why is sql*loader direct path so fast?
How do I tune a sql query?
How do I view an execution plan in sql?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
Can sql developer connect to db2?
What type of database is sql?
What is memory optimized?
Is nosql faster than sql?
How can you view the errors encountered in a trigger?
What is lexical units in pl sql?
How to write html code in pl sql?
How can you select unique records from a table?
What is out parameter used for eventhough return statement can also be used in pl/sql?