how to find the second highest salary from emp table?
Answer Posted / moharaj m
select max(salary) from emp where salary < (select max
(salary) from emp)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is type and rowtype in pl sql?
Is oracle sql free?
What is sql and its types?
What is the reports view in oracle sql developer?
In pl/sql, what is bulk binding, and when/how would it help performance?
what is a unique key ? : Sql dba
How many sql statements are used? Define them.
How do I pipe the output of one isql to another?
What is the use of procedures?
How do sql databases work?
How do I view output in sql developer?
Can we insert data into view?
how can we know the number of days between two given dates using mysql? : Sql dba
how to select unique records from a table? : Sql dba
Is oracel sql developer written in java?