I have a table with two columns team
and date
. The date
column has the date that the entry was added to the table.
I want to print the last 10 entries of each team sorted by date DESC
.
I also want to sort these groups of team entries by date DESC
.
I tried a lot of things, but with no luck. It worked, but with 2 queries which is not acceptable in this case.
How can I do this with a single query? I have the feeling that this is a really newbie question.
See Question&Answers more detail:os