如何从数据库中随机获取用户名 [英] How Can I Get A Username Randomly From Database

问题描述

这是Saradha，我有疑问是否有可能编写SQL查询，每次查询运行时以随机顺序返回表行？请如果有人知道解决方案，请尽快回复我。提前感谢你

This is Saradha,I have a doubt Is it possible to write SQL query that returns table rows in random order every time the query run?please reply me as soon as possible if anyone know the solution..Thanking you in advance

推荐答案

试试：

Try:

SELECT * FROM MyTable ORDER BY NEWID()

您可以使用 RAND（） 实现此目的。

示例：

You can make use of RAND() to achieve this.
Example:

SELECT a,b
FROM 
(
	SELECT 1 a,RAND() b
	UNION
	SELECT 2,RAND()
	UNION 
	SELECT 3,RAND()
	UNION
	SELECT 4,RAND()
) AS T
ORDER BY b

希望，它有帮助：）

Hope, it helps :)

这篇关于如何从数据库中随机获取用户名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！