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
- 20997 Views
- I also Faced
- E-Mail Answers
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 right join sql?
What is procedure function?
What are the steps for performance tuning.
What is a relationship and what are they?
Why function is used in sql?
Is join an inner join?
What are the advantages of sql?
What is sql server and ase?
What is the difference between microsoft access and sql server?
How do I find duplicates in two columns?
What does the file extension accdb stand for?
What is a temp table?
What is sqlerrd?
What is benefit of creating memory optimized table?
What does the argument [or replace] do?
