sqlserver取随机数随机取数

Create Table #AAA(
    WindowNo Varchar(50)
)
Insert Into #AAA(WindowNo)
Values('2窗口')
Insert Into #AAA(WindowNo)
Values('3窗口')

Insert Into #AAA(WindowNo)
Values('6窗口')
Insert Into #AAA(WindowNo)
Values('8窗口')
select top 1 * from #AAA order by newid()

posted @ 2020-09-02 10:12  小美lmt  阅读(524)  评论(0编辑  收藏  举报