Answer / khushbu patel

select dept,count(emp),max(sal)
from a
where age < 25
group by dept
having max(sal) < 20000

Answer / 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

Answer / priya

select dept,count(emp) from employee where age <25 and max
(sal) <20000 group by dept.

Answer / vikneswaran thangarasu

select dept,count(emp),max(sal) from employee where age <25
and sal <20000 group by dept

Answer / pradeep

There is little mistake in Nitin the MONTHS_BETWEEN
(SYSDATE,hiredate)should be stated like this because if we
place hiredate firt the output comes in Negative, so it
gives all record.

select DEPTno,COUNT(EMPno),max(SAL)
from EMP
where (TO_CHAR(sysdate,'yyyy') - TO_CHAR(HIREDATE,'yyyy'))
< 25
GROUP BY DEPTno
having max(sal) < 20000

Answer / nitin umale

SELECT department_id, COUNT(employee_id), MAX(salary)
FROM employees
WHERE MONTHS_BETWEEN(hire_date, SYSDATE) < 25*12
GROUP BY department_id
HAVING MAX(salary) < 20000;

What are the advantages of pl sql?

0 Answers  

What is the difference between local and global temporary table?

0 Answers  

Is pl sql a scripting language?

0 Answers  

What language is oracle sql developer?

0 Answers  

How will you make performance better for application including front end and back

2 Answers   Metric Stream,

What is a primary key, and how is it different from a unique key?

3 Answers  

What is an Exception ? What are types of Exception ?

2 Answers  

How do you write an inner join query?

0 Answers  

What is the difference between inner join and natural join?

0 Answers  

What is #table in sql?

0 Answers  

How do I install microsoft sql?

0 Answers  

Can we use ddl statements in stored procedure?

0 Answers