Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367853 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 / chaitanya pathak
select max(salary) from employee
where salary<(select max(salary) from employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is java sql driver?
What is character functions?
What is the usage of sql functions?
What is the difference between delete and truncate commands?
What is sql*loader and what is it used for?
What are sql objects?
What is numeric function sql?
What are pl/sql packages?
What are different categories of sql commands?
What is a pragma statement?
What is the difference among union, minus and intersect?
What is difference between db2 and sql?
What is schema in sql?
What are sql ddl commands?
What is difference between group by and partition by?
