Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373200 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
Why is sql better than hql?
How to pipe multiline string to isql?
How do I make sql search faster?
what is the use of set statement in tsql? : Transact sql
Can a table contain multiple primary key’s?
What are the types of join and explain each?
Is a view faster than a stored procedure?
What is an alias command?
What is sql keyword?
What are predefined functions in sql?
What are the advantages of pl sql?
How many types of literals are available in pl sql?
How to connect a sql*plus session to an oracle server?
What are all the different types of indexes?
how to create a test table in your mysql server? : Sql dba
