SELECT IN SELECT 第五题
SELECT name,
CONCAT(Round(population/(select population from world where name='Germany')*100,0),'%')
FROM world
WHERE continent='Europe'
得到的百分比虽然四舍五入了,但长这样 3.000000000000%
请问如何只取整数部分
SELECT IN SELECT 第五题
SELECT name,
CONCAT(Round(population/(select population from world where name='Germany')*100,0),'%')
FROM world
WHERE continent='Europe'
得到的百分比虽然四舍五入了,但长这样 3.000000000000%
请问如何只取整数部分