Need to know what SQL clause can categorize rows according to a row content?

I want to display a set of rows according to a culumn x content...