Ptt 大爆卦 | Limit cut - 前往 https://stackoverflow.com/questions/46061007/limit-cut-off-number-returned-by-function-count-in-mysql

你即將離開本站

並前往https://stackoverflow.com/questions/46061007/limit-cut-off-number-returned-by-function-count-in-mysql

**Limit (Cut-off) number returned by function 'count(*)' in MySQL**

You can't put column aliasas in the WHERE clause. Use a derived table instead: select make, num from ( select make,count(*) as num from ...

確定！回上一頁

查詢「Limit cut」的人也找了：