how to find the second highest salary from emp table?
- 211 Answers
- 321329 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
How many unique keys can a table have?
Why do we create stored procedures & functions in pl/sql and how are they different?
Why self join is used in sql?
Are sql connections encrypted?
How can we find duplicate records in a table?
What is an inner join sql?
Does sql require a server?
What is error ora-01000: maximum open cursors exceeded
Are left and right joins the same?
What is a mutating table and a constraining table?
What are the different types of dbmss?
How do I access sql anywhere database?
Whis is not false in primary key?
What is a clob in sql?
Which constraints we can use while creating database in sql?
