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
- 22270 Views
- I also Faced
- E-Mail Answers
Answer Posted / priya
select dept,count(emp) from employee where age <25 and max
(sal) <20000 group by dept.
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is plpgsql language?
what are string data types? : Sql dba
What is pl/sql table? Why it is used?
explain the difference between bool, tinyint and bit. : Sql dba
Explain autonomous transaction.
Explain the working of primary key?
How do I run a pl sql program?
What is error ora-01000: maximum open cursors exceeded
What is a function in oracle pl sql?
How to convert comma separated string to array in pl/sql?
How to get each name only once from an employee table?
Describe types of sql statements?
what is myisam? : Sql dba
Can sql function call stored procedure?
Does sql full backup truncate logs?
