1. Categories >> Software >> Databases >> Databases AllOther
  2. Suggest New Category

write a query for the fifth highest salary?

Question Posted / prasanna

Answer Posted / prasanna

select max(sal) from emp where sal not in (select Top 4 sal
from emp order by sal desc)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp

1644

What is the advantage of varchar2 over char?

799

Can you tell any two advantages of stored procedures?

598

Explain artificial key?

743

What is the difference between oracle and MS Access?

618




Is data lake a database?

570

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

1936

Explain the various types of normalization.

650

What is aws documentdb?

648

Can we use redis as database?

548

What the various ways to tune a teradata query

2796

How do you pass parameter in stored procedure?

734

What happens when shared and exclusive locks are applied on data item?

599

How concurrency problems effect the database?

639

What is a super key?

632