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
- 60333 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / neon
select salary from emp
where salary = (select max(salary) from emp
where salary <>(select max(salary) from emp)
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
How do I find information about the install locations for the various instances running on a computer?
What is the server name in sql server?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Which tcp/ip port does sql server run on? How can it be changed?
What is SubQuery in SQL Server 2008
How to use clusters?
How many types of subqueries are there in sql server?
What stored by the model?
What are Spatial data types in SQL Server 2008
what exactly sql injuction.how to overcome.....
What are statistics?
What is ddl command?
Differentiate between SQL and ORACLE joins and write their syntax.
What is data source view or dsv? : sql server analysis services, ssas
What is the difference between a function and a trigger?
