Write a query to find second highest salary of an employee.
Answer Posted / monika
select max(sal) from emp where sal<select max(sal) from emp
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
how to use myisamchk to check or repair myisam tables? : Sql dba
What is cascade in sql?
What is union and union all keyword in sql and what are their differences?
what are properties of a transaction? : Sql dba
How do I make sql search faster?
How do I access sql anywhere database?
What is using in sql?
What is the difference between the sql*loader and import utilities? : aql loader
what tools available for managing mysql server? : Sql dba
What do you mean by “trigger” in sql?
What is delimiter in pl sql?
Differentiate between sga and pga.
Explain the difference between triggers and constraints?
How many aggregate functions are available there in sql?
What is compiled query?