how to find the second highest salary from emp table?
Answer Posted / chaitanya pathak
select max(salary) from employee
where salary<(select max(salary) from employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between function, procedure and package in pl/sql?
where are cookies actually stored on the hard disk? : Sql dba
What are the types of views in sql?
What does <> sql mean?
who introduced sql?
How to load data with sql*loader?
What does closing a cursor do?
Why query optimization is needed?
How can I speed up sql query?
How many columns should be in an index?
Why stored procedure is better than query?
Why do we use procedures?
how to create a table index in mysql? : Sql dba
What is recursive join in sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba