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 trigger in salesforce?

983

What are the advantages of user defined function?

985

What is the size of transaction log file?

931

How can you stop stored procedures from recompiling?

900

What is command parameter in ssrs?

161

Can you use order by when defining a view?

977

where can you add custom error messages to sql server? : Sql server administration

1120

Difference between LEN() and DATALENGTH() in sql server ?

1105

What are the requirements for sql server 2016?

882

Is mysql the same as sql server?

986

what is sql server? : Sql server database administration

987

What is user-defined function?

975

What is the difference between char, varchar and nvarchar?

1024

Explain a differential backup?

1007

Explain error handling in ssis?

1023