SELECT MIN(sal) FROM (SELECT sal FROM emp ORDER BY sal DESC LIMIT 2) AS a ;

how to find the second highest salary from emp table?

Question Posted / tanmoy

Answer Posted / tanmoy

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are system versioned tables?

1024

what is the difference between join and union? : Sql dba

1111

What are sql objects?

1075

How long it takes to learn pl sql?

1010

what is a cursor? : Sql dba

1021

Why are sql stored procedures used?

1054

What are all the different normalization?

1037

How to create an array in pl/sql?

1066

What are pl/sql cursors?

1049

What are the different types of constraints?

1177

How to convert comma separated string to array in pl/sql?

1177

What is before and after trigger?

955

What is sql*loader and what is it used for?

1148

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1136

what is 'trigger' in sql? : Sql dba

1082