I'm stuck on a query, I'm hoping someone can point me to the obvious
I need to limit the results of a query based on 2 criteria:
1- total rows grouped by column_a
2- total rows all
given:
books: id , author , subject , title
i need to
SELECT * FROM books WHERE subject= 'database'
Limit to : no more than 10 records per 'author'
Limit to : 100 records total
I'm really rusty on my sql this week.
Any pointers would be appreciated.
_________________________________________________________________
Get a FREE Web site, company branded e-mail and more from Microsoft Office
Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/