mysql: select * from tablename order by rand() limit 10 sqlserver: select top 10 * from tablename order by NEWID()
在符合条件的数据中的,从第5条开始提出后面10条数据 mysql: select * from table limit 5,10 sqlserver: SELECT TOP 10 * FROM table WHERE (IDENTITYCOL NOT IN (SELECT TOP 5 IDENTITYCOL FROM table order by IDENTITYCOL)) order by IDENTITYCOL
或: select *,IDENTITY(int,1,1) as Num into ##aa from tablename select * from ##aa where Num >=5 and Num <=10