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

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

1167

What is global database name?

1006

Can you tell any two advantages of stored procedures?

1058

Does facebook use graph database?

1037

wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

3096

Which is the best graph database?

961

What is the difference between data source and database?

1092

What does new grouping sets enables you to do?

1045

How many indexes can be created on a table?

1154

what is the role of auditor in auditing data oriented applications?

2392

WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

2252

What is lagging in DBMS ?

1265

What is the difference between database and server?

1027

What is the best database software for small businesses?

921

what is the full procedure for using store procedure in informatica7.1?

2260