Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
- 8 Answers
- 11931 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is system stored procedures?
Why we should not use triggers?
Define Joins?
What is difference between view and materialized view?
Can primary key be a foreign key?
How do I find sql server instance name?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Write an sql query for deleting duplicate rows?
What is a natural primary key?
Explain the use of containers in ssis and also their types?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Ms sql server index?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
what's the difference between delete table and truncate table commands? : Sql server database administration
What are extended events in sql server?
