select top 100 * from A表 order by newid() 小弟来帮你做点解释: top 100: 表示前100个数字 newid():表示随机
我是在oracle中。 我试了试,好像不行啊! select distinct top 10 phone from A where (date between '01-11-03' and '31-12-03') and (persnnum between '200' and '966' ) order by newid();报错说: select distinct top 10 phone from A * ERROR at line 1: ORA-00923:FROM keyword not found where expected好像不能这样用,不知道有没有其它办法呢?有没有一个以行为单位的随机选取函数呢? 谢谢!
select phone from A where rowsno < 5是rowsno还是rows我记得不太清楚了 你可以查一下oracle的帮助文件的
select top 10 * from ( select distinct phone from A where date between '01-11-03' and '31-12-03' and persnnum between '200' and '966' ) order by newid()
newid()起什么用啊?
小弟来帮你做点解释:
top 100: 表示前100个数字
newid():表示随机
我试了试,好像不行啊!
select distinct top 10 phone from A
where (date between '01-11-03' and '31-12-03')
and (persnnum between '200' and '966' ) order by newid();报错说:
select distinct top 10 phone from A
*
ERROR at line 1:
ORA-00923:FROM keyword not found where expected好像不能这样用,不知道有没有其它办法呢?有没有一个以行为单位的随机选取函数呢?
谢谢!
你可以查一下oracle的帮助文件的
newid()就是实现随机排序功能的.
select distinct phone from A
where date between '01-11-03' and '31-12-03' and
persnnum between '200' and '966'
) order by newid()