write a query to find out the no. of employees whose age is
less than 25 and max of salary for the employees belonging
to a particular department is less than 20000
Answer Posted / vikneswaran thangarasu
Ignore my previous post. it is wrong.
select dept,count(emp),max(sal) from employee where age <25
group by dept having max(sal) <20000
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is try_catch block in procedure
What are commit, rollback, and savepoint?
Can we use delete in merge statement?
Can %notfound return null after a fetch?
What is trigger with example?
What is a dynamic query?
What is sql keyword?
Which is faster count (*) or count 1?
How to pronounce postgresql?
Explain alias in sql?
Define tables and fields in a database
What is difference between hql and sql?
What is the difference between in and between in sql?
What is an escape character in sql?
What is the difference between sql and mysql?