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 delete a row in sql?

949

How do I quit sql?

912

What does a pl/sql package consist of?

944

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3024

Is primary key clustered index?

918

What is a procedure in pl sql?

1156

Can I learn sql in a week?

1031

explain primary keys and auto increment fields in mysql : sql dba

912

how are mysql timestamps seen to a user? : Sql dba

1080

what is blob? : Sql dba

1086

Can we write dml inside a function in sql server?

915

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1190

What is sql stand for?

957

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

960

What is delete command in sql?

1070