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

Is left join faster than inner join?

1130

what is a relationship and what are they? : Sql dba

1105

how to include character strings in sql statements? : Sql dba

1078

Why commit is not used in triggers?

1047

Explain the components of sql?

1068

What is sql catalog?

1028

Can I create table without primary key?

1004

what is datawarehouse? : Sql dba

1026

Where is sql database stored?

988

What is a left inner join?

1022

How many commands are there in sql?

1037

Is stored procedure faster than query?

972

How do I truncate a sql log file?

1079

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

959

What is difference between primary and secondary key?

1033