select a.*,case when chances = (select max(chances)from a )then '12'else null end flag from (SELECT '1'name,FLOOR(1 + (RAND()10))chances union all SELECT '2'name,FLOOR(1 + (RAND()10))chances union all SELECT '3'name,FLOOR(1 + (RAND()10))chances )as a ...
mysql中怎么实现with..as操作，请大神帮忙。
类似这样、用子查询代替：
select
a.*,
case
when
chances
=
(
select
max(chances)
from
a
)
then
'12'
else
null
end
flag
from
(
SELECT
'1'
name,FLOOR(1
+
(RAND()
*
10))
chances
union
all
SELECT
'2'
name,FLOOR(1
+
(RAND()
*
10))
chances
union
all
SELECT
'3'
name,FLOOR(1
+
(RAND()
*
10))
chances
)
as
a2020-04-08
