SELECT
*
FROM
gs_employee_user B
JOIN ( SELECT CEIL( MAX( ID ) * RAND( ) ) AS ID FROM gs_employee_user ) AS m ON B.ID >= m.ID
LIMIT 1
sql随机取一条数据
最新推荐文章于 2022-03-28 10:34:24 发布
SELECT
*
FROM
gs_employee_user B
JOIN ( SELECT CEIL( MAX( ID ) * RAND( ) ) AS ID FROM gs_employee_user ) AS m ON B.ID >= m.ID
LIMIT 1