UPDATE ccaopreport2020 a,
(SELECT COUNT(*) AS qty FROM ccaopreport2020)b
SET percen =FORMAT((1- (seque-1)/b.qty),4)
UPDATE ccaopreport2020 a,
(SELECT COUNT(*) AS qty FROM ccaopreport2020)b
SET percen =FORMAT((1- (seque-1)/b.qty),4)
本文标题：MySQL根据排名计算出击败多少人
本文链接：https://www.haomeiwen.com/subject/idrszktx.html
网友评论