how to find the second highest salary from emp table?
Answer Posted / sreenadh reddy
select max(sal) from emp where sal <(select max(sal) from
emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is left join example?
how do you control the max size of a heap table? : Sql dba
What are the two different parts of the pl/sql packages?
Does truncate require commit?
What is the size of partition table?
What is the difference between inner join and natural join?
What is a sql trace file?
What is sql character function?
What is offset in sql query?
What does an inner join do?
What trigger means?
What is delimiter sql?
What is percent sign in sql?
explain the difference between bool, tinyint and bit. : Sql dba
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba