select ename,salary from (select rownum,ename,salary from emp order by d

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

Question Posted / senorita

Answer Posted / senorita

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

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is difference between hql and native sql?

1186

What are stored procedures in mysql?

1027

What does t sql mean?

955

What is sql query limit?

984

What are character functions?

1097

What are the benefits of triggers?

1181

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1200

How can I change database name in sql?

1095

Does normalization improve performance?

1045

What is sql partition function?

1221

Is sql a oracle?

986

what does the t-sql command ident_current does? : Transact sql

990

Is left join faster than inner join?

1136

What is the difference between sql, mysql and sql server?

1116

What is attribute indicator in pl sql?

1023