Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373302 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
What is pl sql architecture?
what is 'mysqlimport'? : Sql dba
What is anonymous block in sql?
What are sql functions? Describe in brief different types of sql functions?
What are the main features of cursor?
What is before trigger?
How much does a sql dba make? : SQL DBA
How do I tune a sql query?
what is the different between now() and current_date()? : Sql dba
What is #table in sql?
Does inner join remove duplicates?
How do I run a script in sql developer?
What is auto increment in sql?
How to get each name only once from an employee table?
How does cross join work?
