Use this one, should be fine: SELECT T. t_id, T.A, T.B,T.C,t1.cntFROM T INNER JOIN (SELECT A, COUNT(*) AS cntFROM T group by A) t1ON T.A= t1.A 如果不支持inner join,那就用SELECT T. t_id, T.A, T.B,T. C,t1.cntFROM T , (SELECT A, COUNT(*) AS cntFROM T group by A) t1WHERE T.A= t1.A... |