随机查询一条数据

1:
SELECT TOP 1 P.* FROM [ProxyServer] P JOIN (SELECT RAND()*100 AS Nid) T ON P.[Id]>T.Nid WHERE P.Cookie<>'' and P.CompanyID=1069 and P.ProductCode='TPCX'
2:
  SELECT TOP 1 * FROM [ProxyServer] WHERE Cookie<>'' and CompanyID=1069 and ProductCode='TPCX' order by NEWID()

  

posted @ 2016-07-18 16:23  会弹猫的吉他  阅读(257)  评论(0编辑  收藏  举报