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
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Explain the features of oracle?
Can I create users through internet explorer in oracle 10g?
How to get a create statement for an existing table?
Can you assign multiple query result rows to a variable?
What is the difference between substr & instr functions?
How do I reset a sequence in oracle?
What is control file used for?
Explain an exception and its types?
Does oracle charge for java?
What is a trigger and what are its types?
What privilege is needed for a user to query tables in another schema?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What do you mean by cdb and pdb in oracle 12c?
What is the parameter mode that can be passed to a procedure?