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
- 22537 Views
- I also Faced
- E-Mail Answers
Answer Posted / vikneswaran thangarasu
Ignore my previous post. it is wrong.
select dept,count(emp),max(sal) from employee where age <25
group by dept having max(sal) <20000
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Why indexing is needed?
Can we create view in stored procedure?
how to increment dates by 1 in mysql? : Sql dba
What is crud stand for?
What does pragma mean?
What is normalization? How many normalization forms are there?
What are data types in pl sql?
Can unique keys be null?
What is a join?
What are different joins used in sql?
How to process query result in pl/sql?
How sql query is executed?
What is the function that is used to transfer a pl/sql table log to a database table?
Define concurrency control. : Transact sql
How can triggers be used for the table auditing?
