sql - Generating a histogram from column values in a database -

Assume that I have a database column 'grade':

  | Grade | | 1 | | 2 | | 1 | | 3 | | 4 | | 5 |  

Is there such a trivial way in SIL, such as creating a histogram?

  | 2,1,1,1,1,0 |  

Where 2 means that grade 1 comes from two times, 1 means the mean grade {2..5} and 0 means that grade 6 is not at all Happen.

I have no argument that the histogram is a line per count

If this is the case, then SQL Server is accessed by Perl CGI via Unixode / Free TDS is done.

Edit: Thank you for your prompt reply! This is fine if the non-existent value (grade 6 in the example above) does not occur until I can do what the histogram value is from that category.

  from grade to grade  

Select the table, select the grade (grade) but it is not verified, but it does not work, however, it will not show the count for grade 6, because it is not in the table at all ... < / P>