拥有正常的经典,不用担心:
SELECT ID,COUNT(*) FROM User GROUP BY ID
但是使用计算列,它会显示错误
SELECT CONVERT(INT,(ID * PI())) AS TOTO,COUNT(*) FROM User GROUP BY TOTO
你知道有没有办法做到这一点?
SELECT CONVERT(INT,COUNT(*) FROM User GROUP BY CONVERT(INT,(ID * PI()))