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

What is a delimiter in sas?

1129

What is java sql connection?

1120

explain advantages of innodb over myisam. : Sql dba

1175

Name the different types of indexes in sql and define them.

1224

how to convert character strings to numeric values? : Sql dba

1168

What are the different types of database management systems?

1037

What does desc stand for?

1125

Explain the uses of control file.

1100

what are the advantages a stored procedure? : Sql dba

1021

What is cte?

1025

Is left join faster than join?

1096

Describe types of sql statements?

1107

tell us something about heap tables. : Sql dba

1145

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1288

What are the two parts of design view?

1067