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

How do I find my localdb version?

1025

What is difference between inner join and full join?

1111

How do you create an execution plan?

1001

Why use “in” clause in sql server?

1118

How to create a new schema in a database?

1205

do you know how to configure db2 side of the application? : Sql server database administration

1094

What does <> symbol mean?

1026

Do you know what is rank function?

1124

How do I view views in sql server?

1058

What is a performance monitor?

1020

How to copy data from one table to another table?

1050

what's new in sql server 2016?

1003

How use inner join in sql server?

1186

What are security principals used in sql server 2005?

1036

What is the fillfactor concept in indexes?

1033