Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367611 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 / chiguru&
SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to get help at the sql prompt?
What is trigger explain it?
What is primary key and foreign key with example?
explain about mysql and its features. : Sql dba
Does asenumerable execute the query?
What is composite primary key in sql?
How global cursor can be declare with dynamic trigger ?
What is procedure and function in sql?
What is sql performance tuning?
What is file based approach?
What is fmtonly in sql?
How do I sort a table in sql?
What is the primary use of normalization?
Can a commit statement be executed as part of a trigger?
Does truncate remove indexes?
