find out the third highest salary?
Answer Posted / vishawjeet saini
SELECT MIN(sal) FROM emp WHERE
sal IN (select sal from emp order by sal desc limit 3)
Its works on almost databases including postgres.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the oracle differences between nvl and coalesce
What is tns service name?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
Why do you create or replace procedures rather that drop and recreate.
How to retrieve values from data fields in record variables?
Explain rename?
What are the parameters that we can pass through a stored procedure?
Explain the use of grant option in exp command.
Explain temporal data types in oracle
How does one get the view definition of fixed views/tables?
What are the arithmetic operations?
How would you change old and new values in an insert, delete and update triggers?
How to define a specific record type?
How to run the anonymous block again?