how to find the second highest salary from emp table?
Answer Posted / parvezkhan pathan
select max(salary) from emp where salary not in(select
max(salary) from emp);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between nested table and varray?
What is rollback?
Why is pl sql used?
What is the best partition size for windows 10?
What is the syntax and use of the coalesce function?
What is the most restrictive isolation level? : Transact sql
Can cursors be part of a trigger body?
what is collation? : Sql dba
What is relationship? How many types of relationship are there?
How are sql commands classified?
What are the possible values that can be stored in a boolean data field?
How do you rank data in sql?
If a cursor is open, how can we find in a pl/sql block?
Can we use pl sql in sql server?
Is sql similar to python?