SELECT DISTINCT(SAL) FROM EMP WHERE SAL=(SELECT MIN(SAL) FROM (SELECT SAL

how to find the second highest salary from emp table?

Question Posted / neeraj

Answer Posted / neeraj

SELECT DISTINCT(SAL) FROM EMP
WHERE SAL=(SELECT MIN(SAL) FROM (SELECT SAL FROM EMP ORDER
BY SAL DESC)
WHERE ROWNUM<=2);

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Why do we use function in pl sql?

1011

What is sql used for?

1066

Is it possible to create the following trigger: before or after update trigger for each row?

1238

What are the types of queries in sql?

1017

What is java sql driver?

1040

What is row_number () in sql?

935

what is the difference between delete and truncate statement in sql? : Sql dba

1130

What is asqueryable?

905

What does pragma mean?

975

Is sql a backend language?

1043

What is the difference between delete, truncate and drop command?

1063

How do you clear the screen in sql?

1012

What does bitemporal mean?

1010

What is the use of procedures?

926

Can we call a function containing dml statements in a select query?

920