数据库
yk鱼
这个作者很懒,什么都没留下…
展开
-
2021-01-14
提示:SQL Server 阻止了对组件'Ad Hoc Distributed Queries '的STATEMENT 'OpenRowset/OpenDatasource'原创 2021-01-14 15:03:39 · 52 阅读 · 0 评论 -
SQL SERVER , 一些sql语句记录
1.Group by 分组分页 SELECT * FROM ( SELECT ROW_NUMBER() OVER (order by T.LXMC desc)AS Row, * from (select LXMC,count(LXMC) as SL from TableNameWHERE 1=1 group by LXMC ) T ) TT ...原创 2018-10-30 16:44:26 · 1839 阅读 · 2 评论