mssql :
select * from tablename order by newid() desc
在mssql取得随便数据的函数是newid
mysql中:
select * from tablename order by rand() desc
在mysql用来取得随便数据的函数是rand了.
就这么简单,
申明:转载请注来处.
