从数据库SQL 2005中随机选择数据 [英] Random data selection from database sql 2005

问题描述

我在sql 2005中有一个名为[friend]的表
ID FId
1 2
1 3
1 5
2 3
2 4
3 4
3 5

我能够成功选择所有fid，但它们按ID降序排列.我是否可以通过查询使这些FId随机出现?
即
每次刷新页面时，FId的显示位置都应更改.

I have a table in sql 2005 named [friend]
Id FId
1 2
1 3
1 5
2 3
2 4
3 4
3 5

I am able to select all fid successfully but they are ordered in descending by id. Is their any possibility that i can make these FId appear randomly by query.
i.e,
Every time refresh the page the FId displaying position should be changed.

推荐答案

use

use

Order By NewID()

您可以为此使用NEWID 函数.例如

You can use NEWID function for this. For example

SELECT TOP 1 FID
FROM Friend
ORDER BY NEWID()

请参见 TABLESAMPLE [ ^ ]

这篇关于从数据库SQL 2005中随机选择数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！