I want a query that does the following thing,
Select the 10 latest items added in my database, but only the latest item of each category.
id, name, dateadded, categoryid
Query should be something like :
select * from Item
group by categoryid
order by dateadded desc
but I get 0 rows returned.. What's wrong with my query logic?
thanks in advance!