select top 5 * from a where typeid=3 order by newid()
----My SQL方法: ---- SELECT * FROM tb1 ORDER BY RAND() LIMIT 10;----SQL Server方法:---- SELECT TOP 10 * FROM tb1 ORDER BY NEWID()----Oracle 方法: ---- SELECT * FROM ( SELECT * FROM emp ORDER BY DBMS_RANDOM.VALUE ) WHERE rownum<=10;
select top 5 * from a where typeid=3 order by newid()
select top 5* from dbo.MaWorker where typeid=3 order by newid()
SELECT * FROM tb1 ORDER BY RAND() LIMIT 10;----SQL Server方法:----
SELECT TOP 10 * FROM tb1 ORDER BY NEWID()----Oracle 方法: ----
SELECT * FROM (
SELECT * FROM emp
ORDER BY DBMS_RANDOM.VALUE
)
WHERE rownum<=10;
select top 5* from dbo.MaWorker where typeid=3 order by newid()