当天出现次数小于3 [复制链接]

SELECT * FROM j_stock_waizi_now where `stockCode` in (SELECT `stockCode` FROM j_stock_waizi_now  GROUP BY `stockCode` HAVING COUNT(`stockCode`)<3);