Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367591 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
Are stored procedures faster than queries?
What are the different schemas objects that can be created using pl/sql?
What is nosql db?
What are all the ddl commands?
Can we use view in stored procedure?
What is a sql select statement?
how many values can the set function of mysql take? : Sql dba
Can you inner join the same table?
What is meant by temporal data?
What is data type in database?
Enlist the data types that can be used in pl/sql?
What is a left join?
What is a constraint? Tell me about its various levels.
What is the difference between jpql and sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
