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
- 61264 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
what exactly sql injuction.how to overcome.....
What guidelines should be followed to help minimize deadlocks?
How to create indexed view?
between cast and convert which function would you prefer and why?
Give me a SQL Query to find out the second largest company?
What are the types of normalization?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What are system databases into sql server (2005/2008) : sql server database administration
What is SQL Azure Fabric?
How to send a ssrs report from ssis?
what's the maximum size of a row? : Sql server database administration
How to list all login names on the ms sql server?
What is sql view?
How to write character string constants or literals in ms sql server?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
