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

how to find the second highest salary from emp table?

Question Posted / sachin verma

Answer Posted / sachin verma

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

write an sql query to find names of employee start with 'a'? : Sql dba

967

Does sql use python?

978

What is difference between inner join and self join?

1030

Can we use ddl statements in stored procedure sql server?

966

What are %type and %rowtype for?

1014

How many indexes can be created on a table in sql?

989

How you improve the performance of sql*loader? : aql loader

957

what is the difference between join and union? : Sql dba

1030

explain normalization concept? : Sql dba

998

Difference between truncate, delete and drop commands?

1025

How to Execute a Package in PL/SQL.?

1110

What are commit, rollback, and savepoint?

940

What is lookup table in sql?

982

What are the different type of joins in sql?

908

What is sorting in sql?

898