Interested to Buy Any Domain ? << Click Here >> for more details...
Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
- 8 Answers
- 12950 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 the difference between online clustering and Offline clustering?
can SSRS reports Cache results?
Explain powershell included in sql server 2008?
Tell me the difference between clustered and non-clustered index?
What is pivot and unpivot?
Explain syntax for dropping triggers?
What is the difference RDBMS and Graph Database?
Why we should not use triggers?
What is the difference between coalesce() & isnull()?
How can sql server instances be hidden?
Explain the ways to controlling cursor behavior?
What is the syntax for encrypting a column in SQL Server?
application server is slow what may be the problem
How do you delete duplicate records in sql server?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
