asked
Check 0 in a group
Hello All, Is it possible to check whether group of prod,size and cost does not have atleast 1 white color. and can we retain all columns in output (prod,size,cost,nos,color) Prod |size|cost|nos|color Wrangler|L |150$|1 |BLUE Wrangler|L |150$|1 |BLUE Wrangler|L |150$|1 |BLUE Wrangler|L |225$|1 |BLUE Wrangler|XL |225$|1 |BLACK Wrangler|XL |225$|1 |BLACK Wrangler|XL |225$|1 |WHITE Wrangler|XL |225$|1 |WHITE Wrangler|XL |225$|1 |BLUE Wrangler|XL |450$|1 |BLACK Wrangler|XL |450$|1 |BLACK Wrangler|XL |450$|1 |BLACK Wrangler|XL |450$|1 |WHITE Wrangler|XL |450$|1 |WHITE **Output:** **Prod |size|cost|nos|color Wrangler|L |150$|1 |BLUE Wrangler|L |150$|1 |BLUE Wrangler|L |150$|1 |BLUE Wrangler|L |225$|1 |BLUE** as it does not contain atleast 1 white. Please share your view. Thank You Very Much
Something like: select Prod, size, cost, nos from MyTable t where not exists ( select 'has white' from MyTable where Prod = t.Prod and size = t.size and cost = t.cost and colour = 'WHITE' ) Should do the trick
Just checking that you're paying attention of course... \*Cough, cough\*
15 People are following this question.
