how to find the second highest salary from emp table?
Answer Posted / tanmoy
SELECT MIN(sal) FROM (SELECT sal FROM emp ORDER BY sal DESC LIMIT 2) AS a ;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is mutating error in pl sql?
Why plvtab is considered as the easiest way to access the pl/sql table?
What is the use of <> sql?
What is query execution plan in sql?
Explain ttitle and btitle.
What is an oracle stored procedure?
What is function and procedure in pl sql?
Why trigger is used in sql?
Can you sum a count in sql?
what is text? : Sql dba
Is a secondary key the same as a foreign key?
what is the difference between primary key and unique key? : Sql dba
how to enter numeric values as hex numbers? : Sql dba
How do I save a stored procedure?
Can ddl statements be used in pl/sql?