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

sqlserver取随机数随机取数

上一篇:算法笔记


下一篇:6.1 最短路径:Floyd-Warshall算法