how to find the second highest salary from emp table?
Answer Posted / sankar
select * from emp where sal=(select max(sal) from emp where
sal not in(select max(sal) from emp))
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between rename and alias?
What is using in sql?
What is the max nvarchar size?
Why triggers are used?
What is a left join?
How is data stored on a disk?
What are the different type of joins in sql?
What is the source code of a program?
Is subquery faster than join?
How can you load microsoft excel data into oracle? : aql loader
Does view contain data?
How many tables can a sql database have?
What is sql rowcount?
What are the set operators in sql?
how to use like conditions? : Sql dba