ms sql server : select top 100 * from demo order by newid()
my sql server:select * from demo order by rand() limit 10
oracle: select * from demo order by sys_guid() where num>10
ms sql server : select top 100 * from demo order by newid()
my sql server:select * from demo order by rand() limit 10
oracle: select * from demo order by sys_guid() where num>10