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
- 22546 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 a stored procedure? : Sql dba
What is pl sql variable?
Is trigger a stored procedure?
how to check server status with 'mysqladmin'? : Sql dba
Why is pl sql used?
How to find 3rd highest salary of an employee from the employee table in sql?
What is rename in sql?
How do you go back in sql?
What is a native sql query?
What is the difference between in and between in sql?
What is a database trigger?
what is the difference between delete and truncate statement in sql? : Sql dba
What does select count (*) mean in sql?
How many sql statements are used?
Can I call a procedure inside a function?
