select sal from emp where rownum=2 order by sal desc

how to find the second highest salary from emp table?

Question Posted / pradeep

Answer Posted / pradeep

select sal from emp
where rownum=2
order by sal desc

Is This Answer Correct ?

10 Yes

50 No

Please Help Members By Posting Answers For Below Questions

what is collation? : Sql dba

1147

how to check server status with 'mysqladmin'? : Sql dba

1074

Why cross join is used?

1074

what is union? : Sql dba

1025

Why are aggregate functions called so?

946

What do you mean by rowid?

975

How do I copy a table in sql?

983

What are the sql aggregate functions?

1122

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

1223

How to run sql statements through the web interface?

1039

How to process query result in pl/sql?

1128

What is autocommit sql?

985

What is delimiter sql?

985

Can we debug stored procedure?

1019

Is sql a backend?

1015