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
- 20995 Views
- I also Faced
- E-Mail Answers
Answer Posted / khushbu patel
select dept,count(emp),max(sal)
from a
where age < 25
group by dept
having max(sal) < 20000
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
Can we use delete in merge statement?
What is the maximum number of triggers, you can apply on a single table?
What does sql stand for?
How do I view a table in sql?
how to present a past time in hours, minutes and seconds? : Sql dba
What is dcl in sql?
What is the difference between left join and right join?
How many types of triggers exist in pl/sql?
What is the difference between a procedure and a function?
What's the difference between a primary key and a clustered index?
What is int identity in sql?
How do I run a sql query?
Why do we use cursors?
What is the difference between unique and primary key constraints?
Explain what is a view?
