从数据库中随机取8条记录的SQL语句怎么写

[theninthstar]

从数据库中随机取8条记录的SQL语句怎么写

[GageCSDN]

Select Top 8 * From tbl Order By newid()

[ygjwjj]

SQL:
SELECT TOP 8 * FROM TABLE1 WHERE.....ORDER BY NEWID()
AC:
SELECT TOP 8 * FROM TABLE1 WHERE.....ORDER BY RND(ID)

[yezhutou]

哈哈，跟着长了点知识

[wxf0104]

Select Top 8 * From tbl

[iasky]

NEWID()
这个不错，学到了

[sinlo]

ACCESS真的是这样吗?
SELECT TOP 8 * FROM TABLE1 WHERE.....ORDER BY RND(ID)

[caobin518]

学到了一招。哈

[Aa7643]

我也学到了

[超级大笨狼]

<SCRIPT LANGUAGE=vbscript >
'洗牌
Dim N,S,D,P
P=54'牌的数量
Set D = CreateObject("Scripting.Dictionary")
do while D.Count<P
Randomize
N=Int(P * Rnd + 1)
if not D.Exists(cstr(N)) then
D.Add cstr(N),cstr(N)
end if
loop
for each K in D.Keys
S=S & K & " "
next
msgbox replace(trim(S)," ",",")
</SCRIPT>

access
select top 5 * from [table] order by rnd(id)

sql server
select top 5 * from [table] order by newid()

[fj881520]

NEWID()

这是什么意思？？

[doveph]

TOP 8