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
- 22269 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
Where the sql database files are stored?
Is sql a oracle?
how to shutdown mysql server? : Sql dba
What are sql indexes?
How are sql commands classified?
how to enter characters as hex numbers? : Sql dba
What is informix sql?
How to change the order of columns in Oracle SQL Plus ?
What is the difference between distinct and unique in sql?
What are inner and outer joins examples of both?
Is sql developer case sensitive?
What is cursor explain with example?
What is interval partition?
What is the difference between sql and isql*plus?
What is crud sql?
