how to find the second highest salary from emp table?
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
How to load data with sql*loader?
what are the security recommendations while using mysql? : Sql dba
What if we write return in procedure?
What are the types of views in sql?
What are the types of queries in sql?
What is composite data type in pl sql?
give the syntax of grant and revoke commands? : Sql dba
Can I create table without primary key?
How do I copy a table in sql?
How do you change a value in sql?
What is the difference between sum and count in sql?
What is the difference between rollback and rollback to statements?
What are expressions?
What are % type and % rowtype?
Where is pl sql used?