I have a mysql database with users that fall under one of 4 categories. I need to run a query to :
select 4 latest users, 1 from each category.
How can i format my select statement to acomplish this?
the fields to use are:
username, category, signupdate
I'd appreciate any help. Thanks