how to find the second highest salary from emp table?
Answer Posted / abhi
select max(sal)from emp where sal <> (select max(sal)from emp)
OR
select max(sal)from emp where sal < (select max(sal)from emp)
OR
select max(sal)from emp where sal != (select max(sal)from emp)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are triggers in sql?
Can a select statement fire a trigger?
Can we join same table in sql?
Are pl sql variables case sensitive?
What is mutating error in pl sql?
How to install oracle sql developer?
How delete all records from table in sql?
What is a dirty read sql?
What does the sign mean in sql?
How do I install sql?
What is indexing oracle sql?
How to return multiple rows from the stored procedure?
what are date and time intervals? : Sql dba
How to get unique records from a table?
What information is needed to connect sql*plus an oracle server?