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 do I order by ascending in sql?

1089

What is difference between hql and native sql?

1244

Is sql similar to python?

1044

What is gpt format?

997

What are the parts of a sql statement?

1155

What is the least restrictive isolation level? : Transact sql

1114

What is trigger and types?

1074

Can we group by two columns in sql?

1053

what is msql? : Sql dba

1046

How can you view the errors encountered in a trigger?

1027

what is the stuff function and how does it differ from the replace function? : Sql dba

1113

What is a mutating table and a constraining table?

1185

What are local and global variables and their differences?

1143

Why schema is used in sql?

1093

is mysql query is case sensitive? : Sql dba

1170