SELECT * FROM (SELECT ROWNUM DD, M.* FROM (SELECT SAL FROM EMP order by

how to calcuate the second highest salary of he employee

Question Posted / sachin s. patil

Answer Posted / sachin s. patil

SELECT * FROM
(SELECT ROWNUM DD, M.* FROM
(SELECT SAL FROM EMP order by sal desc )M)
WHERE DD=2

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to download oracle sql developer?

1058

Explain sql data types?

1037

What is dbo in sql?

921

What is the use of desc in sql?

916

Is left join faster than inner join?

1065

Explain what is rdbms?

993

Can we call procedure in select statement?

976

What is the importance of sqlcode and sqlerrm?

1280

What are pl sql data types?

957

what is 'mysqlcheck'? : Sql dba

960

Can we use views in stored procedure?

972

How do you update a value in sql?

988

Define commit?

941

what is unique key constraint? : Sql dba

993

Sql technical questions

1203