Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368239 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 / subash pandey
SELECT salary
FROM employee e
WHERE n = (
SELECT count( * )
FROM employee
WHERE salary > e.salary )
n=1 or 2 or 3 n is level which level max salary you want
i test this it proper work
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is information schema in sql?
What is normalization? How many normalization forms are there?
What is sqlerrd?
Name three sql operations that perform a sort.
What is a sql driver?
What steps server process has to take to execute an update statement?
What is clause in sql?
What is percent sign in sql?
Does mysql_real_escape_string prevent sql injection?
What does the sign mean in sql?
What is primary key sql?
what is 'mysqladmin' in mysql? : Sql dba
What does a pl/sql package consist of?
What is $$ in sql?
What is foreign key in sql with example?
