Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367893 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 / hitesh pundir
select max(salary)from m1 where salary <>(select max(salary)
from m1)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain character-manipulation functions?
How many disk partitions should I have?
What are tables in sql?
How do I save a sql query?
What is a parameter query?
how to use case expression? : Sql dba
Does sql*plus also have a pl/sql engine?
How to get each name only once from an employee table?
How do I know if I have sql express or standard?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
Which table is left in left join?
what does myisamchk do? : Sql dba
What is field delimiter?
what is the use of set statement in tsql? : Transact sql
What does joining a thread mean?
