Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367827 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / vinay
It works gr8...
select max(salary) from <table_name> where salary<(select
max(salary)from <table_name>)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Why do we need databases?
What are all different types of collation sensitivity?
What is synchronized subquery?
how would you enter characters as hex numbers? : Sql dba
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Is primary key a clustered index?
What are different types of statements supported by sql?
Does mysql support pl sql?
What does pragma mean?
What are the parameter modes supported by pl/sql?
What is constant in pl sql?
Explain the difference between rename and alias?
How do I order by ascending in sql?
How do you identify a primary key?
How to use sql statements in pl/sql?
