most popular value in a column

[glossen]

if I have 10 records :

ID_______thisval__________name
1________5______________bob
2________3______________bill
3________3______________diane
4________2______________jacko
5________2______________jean
6________3______________gloria

and I want to run a report on the most popular "thisval"
is there anyway to do this in an sql query rather than using alot of CF loops
etc...

i basicly want the output

val_____________countnum
3______________3
2______________2
5______________1

i tried the following but it only returned one column

<cfquery datasource="#datsrc1#" name="getComp" maxrows="10">SELECT
COUNT(DISTINCT thisVal) AS "countNum" FROM table WHERE thisDate >
"#DateFormat(DateAdd("m", -6, now()), "yyyy-mm-dd")#" AND thisVal <> "" ORDER
BY thisVal</cfquery>


TIA =)

[paross1]

<cfquery datasource="#datsrc1#" name="getComp" maxrows="10">
SELECT thisVal,
COUNT(DISTINCT thisVal) AS "countNum"
FROM table
WHERE thisDate > "#DateFormat(DateAdd("m", -6, now()), "yyyy-mm-dd")#"
AND thisVal <> ""
GROUP BY thisVal
ORDER BY 2 DESC
</cfquery>

Phil