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
- 6 Answers
- 20994 Views
- I also Faced
- E-Mail Answers
Answer Posted / nitin umale
SELECT department_id, COUNT(employee_id), MAX(salary)
FROM employees
WHERE MONTHS_BETWEEN(hire_date, SYSDATE) < 25*12
GROUP BY department_id
HAVING MAX(salary) < 20000;
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
Which one is faster ienumerable or iqueryable?
What happens when a trigger is associated to a view?
Can dml statements be used in pl/sql?
What is dml and ddl?
What is the trigger in sql?
What is sql*loader and what is it used for? : aql loader
How do I create a sql database?
What is a sql*loader control file?
What is the use of triggers?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What is nvarchar max in sql?
What does select top 1 do in sql?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is the difference between null value, zero, and blank space?
What is mutating trigger?
