AI摘要
本文介绍了从数据库随机获取一条数据的SQL查询语句。对于MSSQL,使用select top 1 * from user order by newid();而对于MYSQL,使用SELECT * FROM user ORDER BY rand() LIMIT 1。
本文介绍了从数据库随机
MSSQL查询语句:
select top 1 * from user order by newid()
MYSQL查询语句:
SELECT * FROM user ORDER BY rand( ) LIMIT 1