select min(sal) from (select distinct sal from emp order by desc where ro

Write a query to find second highest salary of an employee.

Question Posted / preetir

Answer Posted / preetir

select min(sal) from (select distinct sal from emp order by
desc where rownum < 2)

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain the difference between drop and truncate commands in sql?

1066

what are the differences between char and nchar? : Sql dba

1120

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1216

Is sql low level language?

1026

What is left join in sql?

1060

How to select 10 records from a table?

1167

How many postgresql users are there, worldwide?

1071

What are different types of indexes?

1017

What is dialect in sql?

954

What is sql exception?

980

Does sql full backup truncate logs?

1029

Mention what does the hierarchical profiler does?

1100

Is primary key clustered index?

955

which operator is used in query for pattern matching? : Sql dba

1010

What is sql performance tuning?

929