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
- 22530 Views
- I also Faced
- E-Mail Answers
Answer Posted / vikneswaran thangarasu
select dept,count(emp),max(sal) from employee where age <25
and sal <20000 group by dept
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is varchar example?
What is example of database?
What is primary key and foreign key with example?
explain advantages of myisam over innodb? : Sql dba
What is a full join sql?
Why functions are used in sql?
How are functions and procedures called in PL/SQL?
How many functions are there in sql?
what is the difference between a web-garden and a web-farm? : Sql dba
How many indexes can be created on a table in sql?
What is the difference between sql and mysql?
How does cross join work?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is the file extension for sql database?
Why do we use partitions in sql?
