Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 35 Answers
- 61271 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
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 the difference between having clause and where clause in sql server?
What is replace and stuff function in sql server?
Define outer join?
Which are the third-party tools used in sql server and why would you use them?
Explain what you mean by 3 tier architecture.
What is fill factor and pad index?
Explain the cursor lock types?
List out some of the requirements to set up a sql server failover cluster?
Give main differences between "Truncate" and "Delete".
do views contain data ?
Characterize join and name diverse sorts of joins?
How to turn off warning messages during php execution?
What is a filestream?
What is the usage of sign function?
Do you know how to make remote connection in database?
