1. sql server
select top 10 * from table order by newid()
2. Access
Select top 10 * from table order by rnd(id)
其中id为自增1的字段
3. access + asp
randomize
select top 10 * from table order by rnd(-(id + “ & rnd() & “))”
4. oracle
select * from (select * from table order by sys_guid()) where rownum < 10;
or
select * from (select * from table order by dbms_random.value) where rownum < 10;
5. mysql
select * from table order by rand() limit 10;
select top 10 * from table order by newid()
2. Access
Select top 10 * from table order by rnd(id)
其中id为自增1的字段
3. access + asp
randomize
select top 10 * from table order by rnd(-(id + “ & rnd() & “))”
4. oracle
select * from (select * from table order by sys_guid()) where rownum < 10;
or
select * from (select * from table order by dbms_random.value) where rownum < 10;
5. mysql
select * from table order by rand() limit 10;