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

Do you know concepts and capabilities of sql server?

580

List the different types of joins?

566

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

582

Define Unique Key?

590

Explain the etl (extraction, transformation, and loading)?

556

What are the properties of the transactions?

610

Explain the difference between delete,drop and truncate in SQL Server?

588

What is 1nf 2nf?

543

What is the maximum size of column in sql server?

503

What is a transaction and why is it important?

565

What are the different types of join?

560

Explain indexes disadvantages?

543

How to reaname table name without using sp_Rename in sql server..?

525

What are the two modes of authentication in sql server?

518

Are semicolons required at the end of sql statements in sql server 2005?

565