11 2019 档案

sqlserver分组取top

摘要：select s.* from ( select *, row_number() over (partition by [分组字段] order by [排序字段]) as 别名 from 表名称 ) s where s.别名 = 1 .. 阅读全文

posted @ 2019-11-10 22:15 salv 阅读(804) 评论(0) 推荐(0)

摘要：SELECT datalength(rtrim('是单个12')) 阅读全文

posted @ 2019-11-07 15:53 salv 阅读(2819) 评论(0) 推荐(0)

salv