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
- 51343 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / saikrishna reddy .k
To find second highest salary
select max(sal) from emp where sal not in (select max(sal)
from emp)
to find order
select top 5 8 from emp order by sal desc
| Is This Answer Correct ? | 30 Yes | 17 No |
Post New Answer View All Answers
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What are the requirements on sql server network connections?
Can a rule be bound to any column of any data type?
How can you list all the table constraints in a database?
What is the difference between a fill factor of 100 and 0?
What is cte (common table expression)?
What is the difference between count () and rowcount ()?
How to see existing views in ms sql server?
What is the difference between DATETIME2 and DATETIME?
What is command parameter in ssrs?
What are the events recorded in a transaction log?
How do you know if sql server is running on your local system?
Do you know the cursor optimization tips?
Does union all remove duplicates?
What is difference between cte and view?
