how to find the second highest salary from emp table?
Answer Posted / sudhakar tripathi
select Max(salary) "2nd_Heigh_sal" from employees where
(salary < select Max(salary) from employees);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is database sql?
How do I view tables in mysql?
What is a database? Explain
What is PL/SQL Records?
What is error ora-01000: maximum open cursors exceeded
what are the security recommendations while using mysql? : Sql dba
What is sp_helptext?
what is a cursor? : Sql dba
What is the difference between explicit and implicit cursors in oracle?
What are crud methods?
What is sql injection vulnerability?
What is the maximum rows in csv?
what is user defined functions? : Sql dba
Can you sum a count in sql?
what is try_catch block in procedure