Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / baburav zore
select max(sal) from employee where sal<(select sal from employee);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the differences among rownum, rank and dense_rank? : Sql dba
What are the different types of triggers?
What is oracle sql developer?
i have some prob lem to tell me about my self in interview first round ...
How to start oracle sql developer?
What are character functions in sql?
explain advantages of myisam over innodb? : Sql dba
What is difference between ms sql and mysql?
How would you pass hints to the sql processor?
Does truncate free space?
Can cursors be part of a trigger body?
Is sqlexception checked or unchecked?
what are different types of collation sensitivity? : Sql dba
how do you know if your mysql server is alive? : Sql dba
what is 'mysqlcheck'? : Sql dba