select salary from employee e where 4=(select count(*) from emp f where e

write a query for the fifth highest salary?

Question Posted / suparna

Answer Posted / suparna

select salary from employee e where 4=(select count(*) from
emp f where e.sal<f.sal)

Is This Answer Correct ?

8 Yes

8 No

Please Help Members By Posting Answers For Below Questions

Is it good to store images in database?

1003

what is data access layer?

2400

How to implement database security?

970

What are the tools used for backup and ticketing?

998

What is a sequence? Explain it with one example?

1189

What is the use of default key?

1155

Explain database partitioning. What is its importance?

1195

What does currency type mean in database?

1195

What are different types of clusters present?

1077

List the properties of a transaction.

1058

If the master device is full, how do I make the master database bigger?

989

What is the DIF format and when we will use in teradata

2492

Data structure used to implements a menu:

1164

What is difference between data and database?

1089

What is a Database?

1768