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

In pl/sql, what is bulk binding, and when/how would it help performance?

968

What is character functions?

1034

What is sequence in sql?

972

Which is the correct statement about truncate and delete?

1066

What is difference between hql and native sql?

1124

what is cursor. write example of it. What are the attributes of cursor.

1344

how to include numeric values in sql statements? : Sql dba

1071

what are date and time functions in mysql? : Sql dba

949

what are null values? : Sql dba

919

What are the possible values for the boolean data field?

928

Is pl sql and postgresql same?

1080

What is the difference between jpql and sql?

1052

What is the difference between sql and t sql?

993

What is the function that is used to transfer a pl/sql table log to a database table?

978

What are the parameter modes supported by pl/sql?

1043