how to find the second highest salary from emp table?
- 211 Answers
- 321386 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 / abhay
select max(sal) from emp where sal< (select max(sal) from
emp)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is file based approach?
What is cursor in pl sql?
What is the purpose of design view?
What are sql functions? Describe the different types of sql functions?
What are the two characteristics of a primary key?
What sql does db2 use?
What are tables and fields in the database?
What is a database? Explain
Why do we need a foreign key?
What is a join?
Explain the purpose of %type and %rowtype data types with the example?
What are the syntax and use of the coalesce function?
explain the options of myisamchk to improve the performance of a table. : Sql dba
how do you control the max size of a heap table? : Sql dba
Define commit, rollback and savepoint?
