Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373030 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 / nitin umale
SELECT *
FROM employees
WHERE salary =
( SELECT MIN ( r.salary)
FROM ( SELECT salary
FROM ( SELECT DISTINCT salary
FROM employees
ORDER BY NVL(salary,0) DESC
)
WHERE rownum<3) r
);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How can we solve sql error: ora-00904: invalid identifier?
When sql appeared?
What are tables in sql?
What is the difference between partitioning and sharding?
what are the nonstandard string types? : Sql dba
Explain the uses of a database trigger?
How to write html code in pl sql?
Which kind of parameters cannot have a default value in pl sql?
What does trigger mean in slang?
How do you delete a table?
What is data type in sql?
how many ways we can we find the current date using mysql? : Sql dba
What is a call statement? Explain with an example.
What are sql*plus environment variables?
What is update query?
