select ename,salary from emp where rownum=2 order by salary desc

Write a query to find second highest salary of an employee.

Question Posted / vamana murthy

Answer Posted / vamana murthy

select ename,salary from emp
where rownum=2
order by salary desc

Is This Answer Correct ?

0 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What are the most important ddl statements in sql?

1189

What is the order of sql select?

1088

what is self join and what is the requirement of self join? : Sql dba

1192

How to set up sql*plus output format in oracle?

1082

What is the starting oracle error number?

1100

What are commit, rollback, and savepoint?

1049

Can we create foreign key without primary key?

1040

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7495

what is oracle database ? : Sql dba

1080

What is the best sql course?

1028

Which is better cte or subquery?

1076

What is a table in a database?

1096

What is data control language?

1034

Can sql function call stored procedure?

1074

what are set operators in sql? : Sql dba

1108