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;

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

Define implicit and explicit cursors.

0 Answers  

What is query syntax?

0 Answers  

Does sql backup shrink transaction log?

0 Answers  

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

How to look at the current sql*plus system settings?

0 Answers  

How can I pass the inner procedure value to outer procedure ?

2 Answers  

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

What are pl/sql exceptions? Tell me any three.

1 Answers  

Can I call a procedure inside a function?

0 Answers