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

how to find the second highest salary from emp table?

Question Posted / sarojkant

Answer Posted / sarojkant

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are primary key and foreign key and how they work?

929

What is pl sql code?

995

What are the different operators available in sql?

963

How to pronounce postgresql?

1009

Is crud a cuss word?

975

Is sql a programming?

936

What is row_number () in sql?

935

What is compound trigger?

963

Why do we need databases?

987

What is sql character function?

996

what is bcp? When does it used? : Sql dba

935

What is pl sql package?

993

What is the difference between sql and isql*plus?

1007

How do you delete duplicates in sql query using rowid?

895

what is the difference between primary key and unique key? : Sql dba

972