Doubt in Where and Group by

[NavinReddy]

Hi All,

Could some one help yesterday one interview i face this question

is it possible to use group by and where clause function in one statement

Thanks In Advance

Niranjan

[MayilVahanan · Accepted solution]

Hi

Yes.

Ex:

Test:

Load * Inline

[

Year, Value

2007,4

2007,5

2008,5

2009,2

];

Load Sum(Value) As TValue, Year Resident Test Where Year = 2007 Group by Year;

DROP Table Test;

[Anonymous]

Definately Yes,

Example

Load Month,Year,Sum(Sale) as Sale

from Sales

where match(Year,2012,1013)

group by Month,Year;

Regards

Nitin

[NavinReddy]

HI Guys

Thanks for your valuable information