Oracle学习笔记 随机选择若干数据

参考:
Select *
From (Select Pkid, Knowtype, Worktype, Authority, Score, Question, Answer, Deptcode, Inputperson, Inputdate, Choosetype
From t_Chooseitem
Where 1 = 1
Order By Dbms_Random.Value)
Where Rownum <= 1
阅读更多
想对作者说点什么?

博主推荐

换一批

没有更多推荐了,返回首页