SELECT COUNT(*) FROM city WHERE 50>id; -- 结果果:34
SELECT COUNT(*) FROM city ; -- 结果:3375
-- 问题: 如何用一条sql语句计算出34除以3375的值(0.0101)
SELECT
c.counts / COUNT(*)
FROM
book b,
(
SELECT
COUNT(*) counts
FROM
book
WHERE id > 1000
) c ;
两个count获取除数
最新推荐文章于 2022-09-19 23:14:36 发布