Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / prem chhappesh
select max(salary) from emoplyee where salary not in(select max(salary) from employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can the performance of a trigger be improved?
How do we accept inputs from user during runtime?
What are the sql versions?
What is the largest value that can be stored in a byte data field?
What are the different operators available in sql?
what is difference between delete and truncate commands? : Sql dba
How is sql used in oracle?
What is the difference between sum and count in sql?
what is a database transaction? : Sql dba
what is 'mysqlshow'? : Sql dba
what is the functionality of the function htmlentities? : Sql dba
What is cascade in sql?
Is big data nosql?
What is a field in a database?
what are the disadvantages of mysql? : Sql dba