Quote: Originally Posted by beilstwh There is NO
grouping in your example query. bill, i think he meant that he wants all the rows with the same col2 value to be together, and within those, to be sorted by col1 in other words, he wants ORDER BY col2,col1 i've seen many people use this meaning for "...