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
- 20996 Views
- I also Faced
- E-Mail Answers
Answer Posted / priya
select dept,count(emp) from employee where age <25 and max
(sal) <20000 group by dept.
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
How many postgresql users are there, worldwide?
What is a dirty read sql?
What is normalization in sql?
How do you declare a user-defined exception?
Is it possible to pass parameters to triggers?
what is bdb (berkeleydb)? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
Why self join is used in sql?
Why schema is used in sql?
Can we use ddl statements in stored procedure sql server?
define join and explain different type of joins? : Sql dba
how to return query output in html format? : Sql dba
What are inner and outer joins examples of both?
Is it possible to create startup or shutdown trigger for on-schema?
What is the difference between microsoft sql and mysql?
