group by id order by name desc
SELECT value1, value2, COUNT(value1) AS val FROM table_name GROUP by value1 , value2 HAVING val > 0 ORDER BY value2 DESC
SELECT year, SUM(profit) FROM sales GROUP BY year;
SELECT Username, COUNT(Posts) FROM MyTable GROUP BY Username ORDER BY COUNT(Posts)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)