how to find the second highest salary from emp table?
- 211 Answers
- 320670 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 / muhammed zaheer
select max(sal) from emp where sal < (select max(sal) from
emp)
| Is This Answer Correct ? | 86 Yes | 16 No |
Post New Answer View All Answers
Can we insert delete data in view?
how can we know the number of days between two given dates using mysql? : Sql dba
what is datawarehouse? : Sql dba
How can we implement rollback or commit statement in a trigger?
What is the difference between delete, truncate and drop command?
What are the types of subqueries?
What is a delimiter in sas?
How do you define a foreign key?
What are the properties of a transaction?
What are expressions?
What is difference between primary and secondary key?
What is sql query optimization?
What is the difference between sql and mysql?
What is the command used to fetch the first 5 characters of a string?
Mention what is the use of function "module procedure" in pl/sql?
