NEWID()
関数を利用します。select [列名] from [テーブル名] order by NEWID()
select top([レコード取得件数]) [列名] from [テーブル名] order by NEWID()
select * from contents order by NEWID()
select top(1) * from contents order by NEWID()
select NEWID()
(列名なし) |
441B38F0-0E7C-444F-B46D-E87E41B32AC4 |