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

What are % type and % rowtype?

1028

Are sql database names case sensitive?

1000

what is row? : Sql dba

1224

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1207

Explain what is sql?

1112

What is schema in sql?

946

What is the requirement of self-join?

1127

What are the types of functions in sql?

1015

Is json a nosql?

979

how do you login to mysql using unix shell? : Sql dba

1079

What is exit statement?

1013

What are the types of operators available in sql?

1060

What is dense_rank in sql?

984

How to select 10 records from a table?

1155

How do I make sql search faster?

995