获得随机的n条结果行

select top 5 *
      FROM [Menu]
      order by NEWID()

  select top 5 *
      FROM [Menu]
      order by 6

 

posted @ 2016-08-29 09:16  萧紫紫  阅读(122)  评论(0编辑  收藏  举报