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
- 22798 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 sql keyword?
how many sql dml commands are supported by 'mysql'? : Sql dba
What is information schema in sql?
Is oracel sql developer written in java?
how many groups of data types? : Sql dba
Does truncate table reset auto increment?
What is normalisation in sql?
what is a primary key? : Sql dba
How do you clear the screen in sql?
What is the difference between a primary key and a clustered index?
When can we use the where clause and the having clause?
What is a pragma statement?
Which is faster count (*) or count 1?
What is difference between table and view?
What is embedded sql what are its advantages?
