You have read the manual? http://www.mysql.com/doc/F/u/Full_table.html
Nathan Cook wrote:
>
> When I run this query on a 20,000 record table with 18 fields. The table
> has some identical entries and I am trying to get a count of those entries
> descending.
>
> SELECT
>email,
>fname,
>
When I run this query on a 20,000 record table with 18 fields. The table
has some identical entries and I am trying to get a count of those entries
descending.
SELECT
email,
fname,
lname,
count(email) as emailcount
FROM
referralSpace
GROUP BY
email
ORDER BY
emailcount ASC
LI
