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()

撸起袖子加油干。
原文地址:https://www.cnblogs.com/meitai/p/13600282.html