Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 22256 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
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
How does left join work in sql?
What is the plv (pl/vision) package offers?
How many types of sql are there?
List different type of expressions with the example.
Why is sql better than hql?
Does truncate require commit?
How do I truncate a word?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is the difference between an inner and outer join?
How to get unique records from a table?
How will you distinguish a global variable with a local variable in pl/sql?
What is a .db file?
Define commit?
What is the purpose of cursors in pl/sql?
