34,576
社区成员
发帖
与我相关
我的任务
分享(转帖100分)怎么我的Sql会变成选择全部记录的？
请到这个页面回答问题,谢谢
http://expert.csdn.net/Expert/topic/2369/2369197.xml?temp=6.554812E-02
select top 10 * from T_PRODUCT inner join T_USER on T_PRODUCT.C_USER=T_USER.C_USER where T_USER.site='shundeexpo.com' order by newid()
http://expert.csdn.net/Expert/topic/2369/2369197.xml?temp=6.554812E-02
select top 10 * from T_PRODUCT inner join T_USER on T_PRODUCT.C_USER=T_USER.C_USER where T_USER.site='shundeexpo.com' order by newid()
...全文
请发表友善的回复…
发表回复
yujohny 2003-10-18
- 打赏
- 举报
试试这句：
select top 10 * from (select * from T_PRODUCT inner join T_USER on T_PRODUCT.C_USER=T_USER.C_USER
where T_USER.site='shundeexpo.com') A order by newid()
select top 10 * from (select * from T_PRODUCT inner join T_USER on T_PRODUCT.C_USER=T_USER.C_USER
where T_USER.site='shundeexpo.com') A order by newid()
