Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368414 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 / sudhakar tripathi
select Max(salary) "2nd_Heigh_sal" from employees where
(salary < select Max(salary) from employees);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are different types of functions in sql?
Explain ddl statements in pl/sql?
Why do you partition data?
explain what is mysql? : Sql dba
What types of commands can be executed in sql*plus?
How to add, remove, modify users using sql?
How to use sql*plus built-in timers?
What is data modelling in sql?
What does trigger mean in psychology?
How do you respond to dementia behavior?
Does sql require a server?
Explian rowid, rownum?
what are all the common sql function? : Sql dba
how is myisam table stored? : Sql dba
what are sequences
