select Salary from ( select salary from emp order by desc) as employee wher

write a query for the fifth highest salary?

Question Posted / chethan

Answer Posted / chethan

select Salary from ( select salary from emp order by desc) as employee where rownum = 5;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Under which circumstance should you create an index on a table?

1167

What is database client?

1007

can we delete autodiff back up that we have set through sql server agent.

2202

sparse lookup and where its options we find in OCI and db2?

2224

What is database server and how it works?

1047

What is the use of default key?

1159

What is the purpose of TNS?

1034

What are the most common databases?

973

List some advantages of dbms.

1132

Explain normalization in one line?

1100

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

1135

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2650

What is the role of driver manager?

1017

what are wrappers and build ups and what it's use?

2166

How do I setup a database connection?

1014