TalkPHP - View Single Post - How to get row number from 2 top numberd rows

Wildhoney · 01-27-2009, 02:25 AM

Please try the following query. I hope this is something like what you're after!

sql Code:

SELECT
    country,
    COUNT(*) AS num_entries
FROM
    countries
GROUP BY
    country
ORDER BY
    num_entries DESC

01-27-2009, 02:25 AM	#2 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	Please try the following query. I hope this is something like what you're after! sql Code: SELECT country, COUNT(*) AS num_entries FROM countries GROUP BY country ORDER BY num_entries DESC __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.