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
- 22796 Views
- I also Faced
- E-Mail Answers
Answer Posted / khushbu patel
select dept,count(emp),max(sal)
from a
where age < 25
group by dept
having max(sal) < 20000
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What are the properties of a transaction?
Show how functions and procedures are called in a pl/sql block.
What is an implicit commit?
What is the difference between delete, truncate and drop command?
What is the difference between microsoft access and sql?
Explain the advantages and disadvantages of stored procedure?
How to create your own reports in sql developer?
what is view? : Sql dba
Can we create table inside stored procedure?
What is primary key and foreign key?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
When to use inner join and left join?
How do I truncate a word?
Show the two pl/sql cursor exceptions.
Is sql an operating system?
