Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373185 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 / esakki
select max(salary) from employee where salary not in (select
top 1 salary from employee order by salary desc )
change 1 to 2,3,4,......like that for 3rd max ,4th max
salary.....
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to run sql statements with oracle sql developer?
Is sql low level language?
What is nosql example?
Who developed sql?
What are the ddl commands?
How does sql store data?
how to show all tables with 'mysql'? : Sql dba
How many clustered indexes can be created on a table?
Where is all the data on the internet stored?
What is meant by truncate in sql?
What is oracle pl sql developer?
How do I truncate a sql log file?
How does cross join work in sql?
What is rename in sql?
Explain the types of joins in sql?
