select payout,emp_cd from empmas e where 2>(select count(payout) from em

Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)

Question Posted / suresh

Answer Posted / suresh

select payout,emp_cd from empmas e where 2>(select count(payout) from empmas s where s.payout>e.payout);

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is sql server used for?

1044

How to bind a view to the schema of the underlying tables?

997

Define cursor locking

1003

How to use "begin ... End" statement structures in ms sql server?

1037

How can you hide the sql server instances?

1021

How do you delete duplicate rows in sql server?

955

Does hive support indexing?

959

Define right outer join in sql server joins?

1044

Tell me about the approaches which you used to counter the DI problems.

1348

What is SQL Azure Firewall?

136

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183

Which tcl commands are available on the sql server?

1080

What are the steps to insert a table?

943

Why truncate is ddl command?

1062

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

915