how to find the second highest salary from emp table?
- 211 Answers
- 320873 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 / pramod sharma
select f_name max(salary)from emp,dep
where salary<(select max(salary)from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
Explain the the update statement in sql?
What are the types of variables use in pl sql?
What are joins in sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is the use of index in sql?
Explain the update statement in sql
what is rollback? : Sql dba
What are the different schemas objects that can be created using pl/sql?
Is a secondary key the same as a foreign key?
what is the command line end user interface - mysql? : Sql dba
how to check myisam tables for errors? : Sql dba
How to select unique records from a table?
What is sql trigger example?
Is null operator in sql?
