SQL Server 2008 R2版本如下:
select top 1 *from work order by newid(); --随机取一行
select top 10 *from work order by newid(); --随机取10行
select top 5 *from work order by work.createdate;--获取前5行数据
Oracle 11g版本如下:
select *from (select * from work ORDER BY DBMS_RANDOM.RANDOM()) where rownum < 11;--随机取10行数据、
select *from (select *from work order by work.createdate) where rownum < 6;--获取前5行数据