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 is on delete set null?

1071

what is the difference between myisam static and myisam dynamic? : Sql dba

1051

What is the difference between inner join and left join?

972

How do you delete duplicates in sql query using rowid?

928

How can you view the errors encountered in a trigger?

946

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1123

Is pl sql a programming language?

964

Is ms sql is free?

1008

Are null values same as that of zero or a blank space?

1006

What is right join sql?

951

How many types of indexes are there in sql?

973

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1181

How to get each name only once from an employee table?

1096

Is delete faster than truncate?

994

What is the most restrictive isolation level? : Transact sql

1068