select sal, ename from employee where ROWNUM = 2 order by sal;

how to get second highest salary in SQL(as/4000

Question Posted / siddhartha

Answer Posted / siddhartha

select sal, ename from employee where ROWNUM = 2 order by
sal;

Is This Answer Correct ?

12 Yes

36 No

Please Help Members By Posting Answers For Below Questions

How do you modify a table in sql?

1129

What is an alias command?

1071

how can we know the number of days between two given dates using mysql? : Sql dba

1048

define join and explain different type of joins? : Sql dba

954

What is the maximum number of rows in sql table?

1030

What is sql catalog?

1026

What is a boolean in sql?

985

which operator is used in query for pattern matching? : Sql dba

1009

If a cursor is open, how can we find in a pl/sql block?

1167

Do we need to create index on primary key?

929

Can we use update in sql function?

1066

Can we use rowid as primary key?

989

how can we submit a form without a submit button? : Sql dba

995

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2017

Explain lock escalation? : Transact sql

1203