Hallo, is there a simple way how to select latest articles from each category? This simple query does not work as expected,
SELECT * FROM articles GROUP BY category ORDER BY date because grouping happens first and then the grouped list is ordered. It looks simple but obviously it is not. I have found a solution for selecting top n items from each group here, http://thenoyes.com/littlenoise/?p=36 , but maybe there is already a solution in Sequel? Thanks, jan -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
