SELECT * FROM j_stock_waizi_now where `stockCode` in (SELECT `stockCode` FROM j_stock_waizi_nowGROUP BY `stockCode` HAVING COUNT(`stockCode`)