Three into 1 ! (",)

[team4344]

I have 3 SQL statements.

Does anyone know how i can create simply one statement from these three.

Ideally i would like the statement to return in 3 columns

SELECT Count(Criticality) AS High_Impact
FROM Business
WHERE (((Business.Criticality)="HighImpact&quot);

SELECT Count(Criticality) AS Medium_Impact
FROM Business
WHERE (((Business.Criticality)="MediumImpact&quot);

SELECT Count(Criticality) AS Low_Impact
FROM Business
WHERE (((Business.Criticality)="low Impact&quot);

Many thanks for everyones help.

Olly

 

[JamesLean]

SELECT
  SUM(CASE WHEN criticality = 'highimpact' THEN 1 ELSE 0 END) AS high_impact,
  SUM(CASE WHEN criticality = 'mediumimpact' THEN 1 ELSE 0 END) AS medium_impact,
  SUM(CASE WHEN criticality = 'lowimpact' THEN 1 ELSE 0 END) AS low_impact
FROM business

--James

 

[clarkin]

[tt]SELECT criticality, COUNT(criticality) GROUP BY criticality[/tt]

Posting code? Wrap it with code tags: [ignore]

[/ignore][code]CodeHere

[ignore][/code][/ignore].