how to find the second highest salary from emp table?
- 211 Answers
- 322085 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 / rajesh chauhan
sql>select max(salary)from(select salary from employee where
salary not in(select max(salary)from employee))
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is the use of friend function? : Sql dba
How to select all records from the table?
How to use sql statements in pl/sql?
define sql update statement ? : Sql dba
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
Where the sql database files are stored?
How many joins can you have in sql?
What are the sql commands?
Does access use sql?
How is a PL/SQL code compiled?
what is a table in a database ? : Sql dba
Is it mandatory for the primary key to be given a value when a new record is inserted?
Explain the structure of pl/sql in brief.
Does sqlite need a server?
What is the difference between execution of triggers and stored procedures?
