Friday, 6 September 2013

Nested SQL Queries: How to get mutiple counts on same elements based on different criterias

Nested SQL Queries: How to get mutiple counts on same elements based on
different criterias

I have a table like this :
Server CompliancePercentage
A 25
B 15
C 45
D 75
E 17
F 82
I want to get from a single query the results in the following way:
Conformity% 00-20 20-40 40-60 60-80 80-100
Server Count 2 1 1 1 1
How do I get the above mentioned result from a nested query ? Any help
would be greatful.
Thanks a lot in advance. Suvi

No comments:

Post a Comment