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
- 22799 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
Is keyword pl sql?
how to add a new column to an existing table in mysql? : Sql dba
Why use truncate instead of delete?
What is a natural join sql?
How do you create a db file?
what does the t-sql command ident_incr does? : Transact sql
What is difference between sql and mysql?
When is the update_statistics command used?
How do I count rows in sql query?
Why function is used in sql?
What is the maximum rows in csv?
What is the starting oracle error number?
What is information schema in sql?
Name some usages of database trigger?
What is the requirement of self-join?
