how to find the second highest salary from emp table?
Answer Posted / hitesh pundir
select max(salary)from m1 where salary <>(select max(salary)
from m1)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain raise_application_error.
What are crud methods?
Is sqlite good enough for production?
Could you please provide oca (oracle 10g) dumps for my certification ?
what are rollup and cube in t-sql? : Transact sql
Are sql database names case sensitive?
What does the base_object_type column shows in the user.triggers data dictionary view?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
How can we make an if statement within a select statement?
what are the differences among rownum, rank and dense_rank? : Sql dba
what is the difference between char and varchar data types? : Sql dba
What is the difference between jpql and sql?
Define commit?
Why sql query is slow?
What is sqlcommand?