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
- 22532 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 do I make sql search faster?
what is a composite primary key ? : Sql dba
Describe types of sql statements?
Why commit is not used in triggers?
What is difference between mysql and postgresql?
Where is sql database stored?
How can we find duplicate records in a table?
Is sql a scripting language?
Define sql delete statement.
What is a trigger in sql?
What are the types of views in sql?
What is the purpose of cursors in pl/sql?
What are %type and %rowtype for?
Does view store data in sql?
How does an execution block start and end in pl sql?
