how to find the second highest salary from emp table?
Answer Posted / shiva
select salary from table_name where salary <(select salary
from table_name);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why do we need a foreign key?
What is embedded sql in db2?
what is isam? : Sql dba
Explain the purpose of %type and %rowtype data types with the example?
what tools available for managing mysql server? : Sql dba
What is meaning of <> in sql?
What is the purpose of the partition table?
How to run sql*plus commands in sql developer?
Why do we use sql constraints?
Does oracle roll back the transaction on an error?
Why primary key is required?
What are the different types of joins in sql?
What is difference between stored procedures and application procedures?
How do I install microsoft sql?
What are sql data types?