SELECT kodeagent
, IFNULL((
SELECT COUNT(1)
FROM bsn_data
WHERE bsn_data.periode LIKE '2018-12-%%'
AND bsn_data.kodeupline2 = bsn_kode_agent.kodeagent
AND bsn_data.kodeagent IN(
SELECT bsn_data.kodeagent
FROM bsn_data
WHERE bsn_data.periode LIKE '2018-12-%%'
AND bsn_data.kodeupline2 = bsn_kode_agent.kodeagent
GROUP BY bsn_data.kodeagent ORDER BY COUNT(1) DESC LIMIT 1
)
), 0) AS totps
FROM bsn_kode_agent
WHERE fungsi = 'sales agent'
ORDER BY totps DESC
得到结果
此版本的mariadb尚不支持“limit&in/all/any/some subquery”
我该怎么解决?我要在子查询中添加限制查询..谢谢您。。
