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

Why do we use joins?

1023

What is trigger point?

978

What is auto increment feature in sql?

1111

What is the difference between sql, mysql and sql server?

1070

Explain polymorphism in pl/sql.

1102

what does the t-sql command ident_incr does? : Transact sql

1054

what is dbms? : Sql dba

975

Which sql statement is used to delete data from a database?

942

Explain the significance of the & and && operators in pl sql.

991

What is data control language?

976

what are the different index configurations a table can have? : Sql dba

984

Does user triggers have entry for trigger with compilation errors?

1022

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1051

Can pl sql procedure have a return statement?

1005

What is rownum?

966