Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
- 8 Answers
- 13634 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
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is the primary use of the model database?
How do I create a trace in sql server?
what is the difference between openrowset and openquery?
What is self contained sub query?
What are the different SQL Server Versions you have worked on?
How can I check that whether automatic statistic update is enabled or not?
Can sql servers link to other servers like oracle?
what is spatial nonclustered index
Why should you use or avoid select * statements?
What is acid mean in sql server?
What is a scheduled job or what is a scheduled task?
How do I find the sql server version?
List the ways in which dynamic sql can be executed?
What is the difference between upgrade and migration in sql server?
