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
- 22536 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 expressions?
How do you determine the current isolation level? : Transact sql
What is a string data type in sql?
How to display the records between two range in Oracle SQL Plus?
What can you do with pl sql?
What are all the different types of indexes?
Why are sql stored procedures used?
Does oracle roll back the transaction on an error?
What is trigger in pl sql?
What are the various levels of constraints?
What is an emotional trigger?
Which is better cte or subquery?
Write a query to display the current date in sql?
Why do we need cursor in pl sql?
What do you understand by exception handling in pl/sql?
