If I have multiple items listed in a where clause How would one go about limiting the results to N for each item in the list?
EX:
select a_id,b,c, count(*), as sumrequests
from table_name
where
a_id in (1,2,3)
group by a_id,b,c
limit 10000
If I have multiple items listed in a where clause How would one go about limiting the results to N for each item in the list?
EX:
select a_id,b,c, count(*), as sumrequests
from table_name
where
a_id in (1,2,3)
group by a_id,b,c
limit 10000