How To Sort Item With The Same Value Using Cdbcriteria?

I have table name classification and columns ‘class_id’ and ‘class_name’. Now, I want to display a list of objects that belongs to same classification using CDbCriteria.

Ex. Classification[list=1]

[*]Equipment -3

[*]Crops -2

[*]Services -1


How can I display only items that has value and their count that belongs to class ‘Equipment’, etc.? If there is no item that belongs to class Crops ( Crops=0), no need to display.

Thank you. Hope you can help me.