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
- 55037 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
How do I change my passwords (database, LDAP, and so on) without causing an outage?
How to automatically create a log when an exception is being received into SQL Server?
What are the new features of sql server 2012 reporting service?
How do you rename a table in sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
How to apply filtering criteria at group level with the having clause in ms sql server?
What is a fill factor?
What is mean by dml?
What is the difference between primary key and unique constraints?
What is triggers and its types?
Can you name a few encryption mechanisms in sql server?
What is merge replication?
What is “asynchronous” communication in sql server service broker?
Create and insert into temp table in sql server?
How many types of the database links?
