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

Does sql view stored data?

955

what is the different between now() and current_date()? : Sql dba

1016

Explain architecture of sql server notification services?

1054

How exception handling is done in advance pl/sql?

979

What is a nested table in word?

954

Why is sql*loader direct path so fast?

1101

What are inbuilt functions in sql?

1054

What is a relationship and what are they?

1148

what are the nonstandard string types? : Sql dba

1134

How many types of cursors are available in pl/sql?

1107

How many types of indexes are there in sql?

983

What is difference between sql and excel?

1089

What are the two virtual tables available at the time of database trigger execution?

1222

What is consistency?

1117

Is sql an operating system?

1017