select top 100 *, NewID() as random from heart order by random
另一种更简单的写法:
SELECT * FROM dbo.mb_access_number WHERE nation_code='CA' AND client_type='iphone' AND city='Winnipeg'
ORDER BY NEWID()
-- 直接在最后加:ORDER BY NEWID()
select top 100 *, NewID() as random from heart order by random
另一种更简单的写法:
SELECT * FROM dbo.mb_access_number WHERE nation_code='CA' AND client_type='iphone' AND city='Winnipeg'
ORDER BY NEWID()
-- 直接在最后加:ORDER BY NEWID()