combingin two 'where' statements

[tommot82]

Is there any neat way i can combine the following two statements to return me a single table of results with the columns:
lt2, lt3, id

select count(*) lt2,id
FROM TABLE
where Value<2
GROUP BY id

select count(*) lt3,id
FROM TABLE
where Value<3
GROUP BY id

Thanks for your help
tommot82

 

[PHV]

SELECT id,
SUM(CASE WHEN Value<2 THEN 1 ELSE 0 END) lt2,
SUM(CASE WHEN Value<3 THEN 1 ELSE 0 END) lt3
FROM TABLE
WHERE Value<3
GROUP BY id

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tommot82]

nice one thankyou very much!! Much appreciated