ASP随机调用数据,不重复

 
像下面的代码,如果随机从news_info所有数据库中随机调出6条记录,我看网上有很多种,但没有一种能用的.帮帮我,最好是实例,SQL数据库


<%
      set rs=server.CreateObject("adodb.recordset")
  rs.open"select top 6 * from news_info  order by id desc ",conn,1,1
      do while not rs.eof
%>


  <%
rs.movenext
loop
rs.close%>

---

select top 6 * from news_info  order by newid() desc

---

select top 6 * from news_info  order by newid()

---

order by newid()