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随机取一条数据
最新推荐文章于 2024-05-28 11:34:17 发布
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