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
- 20436 Views
- I also Faced
- E-Mail Answers
Answer Posted / vikneswaran thangarasu
select dept,count(emp),max(sal) from employee where age <25
and sal <20000 group by dept
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
how is exception handling handled in mysql? : Sql dba
What is #table in sql?
What are different types of indexes?
What is a system versioned table?
What is a primary key example?
what are the nonstandard string types? : Sql dba
How can I change database name in sql?
How can you load multi line records? : aql loader
Explain table and field in sql?
what is try_catch block in procedure
What is an example of translating a date into julian format?
How do I enable sql encryption?
What is the difference between inner join and natural join?
Why function is used in sql?
