select * from (select sal,rownum rn from(select sal from emp order by sal d

how to get second highest salary in SQL(as/4000

Question Posted / mohamed shahid

Answer Posted / mohamed shahid

select * from (select sal,rownum rn from(select sal from emp order by sal desc)) where rn=2;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to know the last executed procedure?

1105

what is error ora-03113: end-of-file on communication channel?

1171

What will you get by the cursor attribute sql%notfound?

1090

Can we rollback after truncate?

1035

What is the use of stored procedures?

1055

What is scalar and vector?

1010

How to select all records from the table?

1150

what is a database? : Sql dba

1183

How many sectors are in a partition?

1085

What is difference between cursor and trigger?

1085

What are the types of functions in sql?

1027

What is the source code of a program?

1077

Can we join same table in sql?

1034

What is the maximum number of rows in sql table?

1034

what are the advantages and disadvantages of views in a database? : Sql dba

1045