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
- 22271 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
How do you bind variables in pl sql?
Mention what are the benefits of pl/sql packages?
Why do we use procedures in sql?
Does sql backup shrink transaction log?
What is the best free sql database?
Is subquery faster than join?
What are all the different types of indexes?
What do you think about pl/sql?
Explain the purpose of %type and %rowtype data types with the example?
What is sql partition?
What is identity column in sql server?
How do you declare a constant?
Which command is used to call a stored procedure?
What is information schema in sql?
what is the difference between nested subquery and correlated subquery?
