GROUP BY problem

[ozzyman]

I want to take last 10 voted members by excluding same members.
Table is like this:

id / member / vote
1 / 10 / 1
2 / 15 / 0
3 / 32 / 0
4 / 10 / 0

I think this query is ok but not working:
SELECT member, COUNT(*) FROM table GROUP BY member ORDER BY id DESC LIMIT 10

What do you think?

[ChadSEO]

ozzyman,

It will probably complain about the ORDER BY clause, specifically the 'id' - this might work better:

SELECT member, COUNT(*) FROM table GROUP BY member ORDER BY max(id) DESC LIMIT 10

Hope that helps!

Chad

[ozzyman]

Thanks chad but it gives "Invalid use of group function" error
Any idea?

[Demaestro]

Try:

SELECT member, COUNT(member) FROM table GROUP BY member ORDER BY max(id) DESC LIMIT 10

[ozzyman]

Damaestro it give same error above.

I found the solution from another board. Here is the query maybe helps somebody else too:

select member
   , max(id) as last_id
 from daTable
group
  by member
order
  by last_id desc limit 10