If I have a table with 100 products in it, half are from Brand A, half are from Brand B. How do I say:
SELECT * FROM table_name
BUT ... show 10 products from Brand A and 10 products from Brand B
Maybe it's early but I can't quite get my head around how to write this query.