Select top 2 sal from (select sal from emp order by sal desc)

how to find the second highest salary from emp table?

Question Posted / sheela

Answer Posted / sheela

Select top 2 sal from (select sal from emp order by sal
desc)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a mutating table and a constraining table?

1120

What is the difference between left join and right join?

950

Explain ttitle and btitle.

1124

What is the requirement of self-join?

1133

What is mutating error?

973

How to return multiple rows from the stored procedure?

975

What is parallel hint?

1332

How many functions are there in sql?

1042

How to display the records between two range in Oracle SQL Plus?

1153

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1073

What are dml commands?

1026

How do I quit sql?

965

Can you have a foreign key without a primary key?

956

What are views in sql?

995

What are the disadvantages of file system?

1271