帮朋友改个asp的相关产品显示要用到随机读取当前类别的前10个产品，google了下收藏的
mysql中随机提取数据库记录
-------------------------------------------------------------------------------- view plaincopy to clipboardprint?
select * from tablename order by rand() limit 10
select * from tablename order by rand() limit 10sqlserver中随机提取数据库记录
-------------------------------------------------------------------------------- view plaincopy to clipboardprint?
select top 10 * from tablename order by newid()
select top 10 * from tablename order by newid()access中随机提取数据库记录
-------------------------------------------------------------------------------- view plaincopy to clipboardprint?
select top 10 * from tablename order by rnd(fid)
select top 10 * from tablename order by rnd(fid)fid:为你当前表的id字段名