我有以下疑问:SELECThostVersion,CONVERT(varchar,100.0*count(*)/tot,1)+'%'as'Percent'FROMhostInfo,(SELECTCOUNT(*)astotFROMhostInfo)xGROUPBYhostVersion,tot并收到以下输出:+--------------------------------+|hostVersion|Percent|+--------------------------------+|5.0.0|26.666666666666%|+----------------------------

我有以下疑问:SELECThostVersion,CONVERT(varchar,100.0*count(*)/tot,1)+'%'as'Percent'FROMhostInfo,(SELECTCOUNT(*)astotFROMhostInfo)xGROUPBYhostVersion,tot并收到以下输出:+--------------------------------+|hostVersion|Percent|+--------------------------------+|5.0.0|26.666666666666%|+----------------------------