也就是如下两天SQL是否一样:SELECT name, RAND() FROM t ORDER BY RAND() LIMIT 10;
与
SELECT name, RAND() AS rd FROM t ORDER BY rd LIMIT 10;
还有就是RAND()产生的数据放在哪?
与
SELECT name, RAND() AS rd FROM t ORDER BY rd LIMIT 10;
还有就是RAND()产生的数据放在哪?
SELECT name, RAND() FROM t ORDER BY RAND() LIMIT 10;
整个详细的执行过程是怎样的?