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
- 61226 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / harsha
select * from my_table1 where sal not in (select max(sal)
from my_table1) order by Sal desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
When you use @@error and try-catch?
What are the authentication modes in sql server? How can it be changed?
How to connect php with different port numbers?
What is page-level compression?
What is the difference between ddl,dml and dcl commands?
What do you mean by the term 'normalization'?
What are the types of user defined functions in sql server?
What are the limitations/drawbacks or ssrs 2008 r2?
What are the differences between decimal and float in ms sql server?
What is the maximum row of a size?
How to check table values in sql server?
Explain some stored procedure creating best practices or guidelines?
What is the difference between indexing and hashing?
What are the export options of ssrs?
What is a benefit of using an after insert trigger over using a before insert trigger?
