SQL - Which clause you use to exclude the rows before grouping them?A. Group ByB. HavingC. WhereD. Minus

GeekInterview.com > Placement Papers > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 26 of 32

Which clause you use to exclude the rows before grouping them?

A. Group By
B. Having
C. Where
D. Minus

Total Answers and Comments: 7

Last Update: July 17, 2008

Sponsored Links

Best Rated Answer

—

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

July 28, 2005 09:13:20

kranti

RE: Which clause you use to exclude the rows before grouping them?A. Group ByB. HavingC. WhereD. Minus

having

Is this answer useful? Yes | No

November 22, 2005 04:38:38

Divakala

Member Since: November 2005 Contribution: 3

RE: Which clause you use to exclude the rows before grouping them?

A. Group By
B. Having
C

kranti Wrote: having

Hi,

Having clause is used to apply some condition on the data that is retrieved by using Group by and select from that.

sree

Is this answer useful? Yes | No

December 16, 2005 15:20:17

sofia

Member Since: December 2005 Contribution: 7

RE: Which clause you use to exclude the rows before gr...

where clause

Is this answer useful? Yes | No

November 07, 2006 05:46:38

sandeep

RE: Which clause you use to exclude the rows before gr...

where is correct

Is this answer useful? Yes | No

August 29, 2007 13:39:49

sindhu

RE: Which clause you use to exclude the rows before gr...

When "having, groupby, where" are present in the same statement, the order of execution is
1. Where
2. Group By
3. Having

Is this answer useful? Yes | No

June 14, 2008 05:48:16

ravi.8311

Member Since: June 2008 Contribution: 7

RE: Which clause you use to exclude the rows before grouping them?A. Group ByB. HavingC. WhereD. Minus

group by clause

Is this answer useful? Yes | No

July 17, 2008 02:42:12

krishnaveni_g

Member Since: July 2008 Contribution: 10

RE: Which clause you use to exclude the rows before grouping them?A. Group ByB. HavingC. WhereD. Minus

Where clause is the correct answer. Order of execution is

where
group by
having

Is this answer useful? Yes | No

Go To Top