1、如果是SQL的话,可以用下面的方式
select top 10 * from table order by newid( )
2、如果是Oracle
select * from (
select * from table
order by dbms_random.value
)
where rownum <= 10;
3、如果是Access
SELECT top 10 * FROM table ORDER BY Rnd(id)
ID是自增长一个列
4、如果是MySQL
select * from table order by rand() limit 10
select top 10 * from table order by newid( )
2、如果是Oracle
select * from (
select * from table
order by dbms_random.value
)
where rownum <= 10;
3、如果是Access
SELECT top 10 * FROM table ORDER BY Rnd(id)
ID是自增长一个列
4、如果是MySQL
select * from table order by rand() limit 10