how to find the second highest salary from emp table?
Answer Posted / anantkreshna v
select max(sal) from emp_table where sal < (select max(sal)
from emp_table);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how can we know the number of days between two given dates using mysql? : Sql dba
Is left join inner or outer by default?
Can we rollback delete command?
What is bind variable in pl sql?
What is sql rowcount?
Is a foreign key always unique?
What is sql deadlock?
how to create a test table in your mysql server? : Sql dba
What is the difference between the conventional and direct path loader? : aql loader
What is sql stand for?
Explain the working of foreign key?
How can we link a sql database to an existing android app?
What is benefit of creating memory optimized table?
What is the difference between sum and count in sql?
Can we commit inside a trigger?