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
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 is %type in pl sql?
What is the purpose of a secondary key?
Explain what is a subquery ?
What is the most important ddl statements in sql are?
How many types of indexes are there in sql?
What is the difference among union, minus and intersect?
what is the command line end user interface - mysql? : Sql dba
Explain the working of foreign key?
Does execute immediate commit?
What are actual parameters and formal parameters?
What is the difference between sql and mysql?
What is the difference between function, procedure and package in pl/sql?
What is primary key in db?
What is sql comments?
What are the syntax and use of the coalesce function?