我使用了两次相同的选择查询。如何将其更改为一个查询或别名?
我代码:select *
from
(
select store, count(*) as quantity
from bbb
where MONTH(date) = 12
group by store
) as december
having quantity = (select MAX(maxi)
from
(
select store, count(*) as maxi
from bbb
where MONTH(date) = 12
group by store) as december
)
如果您想选择一个top-count store,使用:
SELECT store, COUNT(*) AS quantity
FROM bbb
WHERE MONTH(datE) = 12
GROUP BY
store
ORDER BY
quantity DESC
LIMIT 1
与原始查询不同,此查询不会返回可能的关联。