SQL Plus - The use of HAVING , WHERE and GROUPBY in one SQL

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 62 of 132

The use of HAVING , WHERE and GROUPBY in one SQL

Total Answers and Comments: 3

Last Update: March 23, 2009

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 28, 2005 04:56:20

Swapnil

RE: The use of HAVING , WHERE and GROUPBY in one SQL

where filters data before grouping
Having filters data after grouping

Is this answer useful? Yes | No

October 23, 2006 10:55:40

thumatinagaraju

RE: The use of HAVING , WHERE and GROUPBY in one SQL

hiin where condition we cann't use group function but having clause allows it both r used 4 data restriction only.group by is used 4 grouping similar items.

Is this answer useful? Yes | No

March 23, 2009 06:48:29

sharmasl

Member Since: March 2009 Contribution: 10

RE: The use of HAVING , WHERE and GROUPBY in one SQL

select deptno sum(sal) from emp
where (deptno 10 or deptno 20)
group by deptno
having sum(sal)> 10000;

The Ans is:-

DEPTNO SUM(SAL)
------ ----------
20 11675

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank