Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373319 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 / rajesh chauhan
sql>select max(salary)from(select salary from employee where
salary not in(select max(salary)from employee))
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do I access sql anywhere database?
Does postgresql run on the cloud?
How does a covering index work?
Explain the difference between triggers and constraints?
Can we use two order by clause in query?
What is the purpose of primary key?
What are conditional predicates?
Does a primary key have to be a number?
What is trigger with example?
What is the default isolation level in sql server? : Transact sql
what is top in tsql? : Transact sql
how do you login to mysql using unix shell? : Sql dba
What are the sql commands?
what is cross join? : Sql dba
what is row? : Sql dba
