Hi,

Thanks for replying me. I got stuck after "Having Exists".. the serch condition should take the groups which has max(a.thevalue) greater thaen 3. that I cannot figure out hw it...

I didnt get the exists condition here.. hw it works? can anyone explain me plz?

Thanks,

rahul

try this:

CREATE TABLE MyTable (MyId INT IDENTITY (1,1),

...