How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
Answer Posted / rajeev
select salary-1 from users where salary in (select
max(salary) from users);
Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What is sql server schema compare? How we can compare two database schemas?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What types of replication are supported in sql server?
Do you know what are the ways available in sql server to execute sql statements?
Determine when an index is appropriate?
What is cross join in sql server joins?
What is entity data services?
What is a heap?
How to declare and use cursor variables?
What is the difference between TRUNCATE and DROP?
What is CTE in SQL
Explain few of the new features of sql server 2008 management studio
How to create median function?
Explain differentiate between a having clause and a where clause?
Explain forward - only cursors?