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

how to calcuate the second highest salary of he employee

Question Posted / sachin s. patil

13 Answers
19005 Views
Synechron, I also Faced
E-Mail Answers

Answer Posted / sachin s. patil

SELECT SAL FROM
(SELECT ROWNUM DD, M.* FROM
(SELECT SAL FROM EMP order by sal desc )M)
WHERE DD=2/***HERE U CAN ADD ANY NUMBER (WHERE I PUT 2)
, U WILL GET HEIGHEST SALARY THAT POSITION *******/

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1211

Can we use update in sql function?

1116

What does subquery mean in sql?

1117

what is difference between delete and truncate commands? : Sql dba

1180

What is dbo in sql?

1022

What is left join example?

1009

What is column?

1041

tell me about various levels of constraint. : Sql dba

1087

What is dense_rank?

991

What is a scalar value in sql?

1130

Is foreign key mandatory?

1064

What is loop in pl sql?

1085

What are transaction and its controls?

1092

Can you have more than one trigger on a table?

1050

How many triggers can be applied on a table?

992