Junior Member
joined:May 7, 2005
posts: 143
votes: 0
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
LIMIT 20
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.
Thanks!