CodingForums.com - View Single Post

Radeom · 12-01-2012, 12:55 PM

PHP Code:


			
SELECT country, count(distinct name) AS theCount FROM names GROUP BY country ORDER BY theCount DESC

result is:

Code:

Sweden 4
Denmark 3
Germany 1

because no id
it does not work:

PHP Code:


			
SELECT country, count(distinct name and id) AS theCount FROM names GROUP BY country ORDER BY theCount DESC

12-01-2012, 12:55 PM	PM User \| #3
Radeom New Coder Join Date: May 2012 Posts: 20 Thanks: 0 Thanked 0 Times in 0 Posts	PHP Code: `SELECT country, count(distinct name) AS theCount FROM names GROUP BY country ORDER BY theCount DESC` result is: Code: Sweden 4 Denmark 3 Germany 1 because no id it does not work: PHP Code: `SELECT country, count(distinct name and id) AS theCount FROM names GROUP BY country ORDER BY theCount DESC`