Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367630 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 / mangesh pardhi
SELECT salary
FROM employee e
WHERE 2=(SELECT COUNT(DISTINCT salary)
FROM employees
WHERE e.salary<=salary)
--replace the number with 2,3,4 u wil find the that position
salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is a trigger in mysql? : Sql dba
Can we rollback delete command?
What is pragma in sql?
How many types of cursors are available in pl/sql?
what is 'mysqlcheck'? : Sql dba
How to order siblings in oracle hierarchy queries?
Is primary key clustered index?
How do I view a procedure in sql?
What is indexing oracle sql?
What information is needed to connect sql*plus an oracle server?
What are all the ddl commands?
What are predefined functions in sql?
How do you change a value in sql?
what is primary key? : Sql dba
Can we change the table name in sql?
