how to find the second highest salary from emp table?
Answer Posted / sathiavathi
select max(salary) from employee where salary!=(select max
(salary) from employee);
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is informix sql?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is the use of %rowtype?
Does postgresql run on the cloud?
What is sql architecture?
what is uncommittable transactions? : Transact sql
Explain what is table in a database?
What is an exception in pl/sql?
What is embedded sql what are its advantages?
what is the difference difference between procedure and packages
What is difference between stored procedure and trigger?
Can we use distinct and group by together?
What is partition by in sql?
what is myisam? : Sql dba
How do I audit the sql sent to the server?