Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361396 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 / ankit khanijau
Select salary from emp
where MAX(Select salary from emp where salary != MAX(salary))
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Are stored procedures faster than dynamic sql?
How to write html code in pl sql?
How many parts of a pl sql block are optional?
What is delimiter in pl sql?
What are the advantages of indexing?
Why do we use set serveroutput on?
what are the disadvantages of mysql? : Sql dba
What are the different types of tables in sql?
What is sql in oracle?
What is difference sql and mysql?
what is rollback? : Sql dba
What does desc stand for?
What is meant by temporal data?
What is the difference between sum and count in sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
