SELECT MIN(sal) FROM emp WHERE sal IN (select sal from emp order by sal d

find out the third highest salary?

Question Posted / vishawjeet saini

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

Please Help Members By Posting Answers For Below Questions

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2307

Explain the features of oracle?

1109

Can I create users through internet explorer in oracle 10g?

1158

How to get a create statement for an existing table?

1016

Can you assign multiple query result rows to a variable?

1039

What is the difference between substr & instr functions?

1295

How do I reset a sequence in oracle?

1155

What is control file used for?

1303

Explain an exception and its types?

1141

Does oracle charge for java?

1115

What is a trigger and what are its types?

1330

What privilege is needed for a user to query tables in another schema?

1033

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1710

What do you mean by cdb and pdb in oracle 12c?

1102

What is the parameter mode that can be passed to a procedure?

1111