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 are some examples of schemas?

972

List out the different types of locks available in sql server?

974

Can primary key be null?

926

What is the full form of dql?

978

What is merge replication?

1099

Give me any three differences between Truncate and Delete.

1100

Explain nested join?

974

What is the use of set nocount on/off statement?

1093

What do you understand by a view? What does the with check option clause for a view do?

994

What is acid properties?

1088

What is the difference between varchar and varchar(max) datatypes?

1065

How do I delete a sql server database?

1039

How check triggers in sql server?

984

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

934

Explain about service Broker functions?

1028