求sql：按雷同日期分组并显示组号
日期：2014-05-17 浏览次数：20495 次
求sql：按相同日期分组并显示组号
如题：
------解决方案--------------------
------解决方案--------------------
如题：
create table #t(s_time datetime,na varchar(20))
insert #t
select '2013-10-1','aa'
union all
select '2013-10-1','bb'
union all
select '2013-10-1','cc'
union all
select '2013-10-15','dd'
union all
select '2013-10-15','ee'
union all
select '2013-10-20','ff'
select * from #t
/*
希望得到的结果
group_no s_time na
1 2013-10-01 aa
1 2013-10-01 bb
1 2013-10-01 cc
2 2013-10-15 dd
2 2013-10-15 ee
3 2013-10-20 ff
*/
sql
排序
分组
------解决方案--------------------
create table #t(s_time datetime,na varchar(20))
insert #t
select '2013-10-1','aa'
union all
select '2013-10-1','bb'
union all
select '2013-10-1','cc'
union all
select '2013-10-15','dd'
union all
select '2013-10-15','ee'
union all
select '2013-10-20','ff'
select DENSE_RANK()over(order by s_time) as group_no,* from #t
drop table #t
--
group_no s_time na
-------------------- ----------------------- --------------------
1 2013-10-01 00:00:00.000 aa
1 2013-10-01 00:00:00.000 bb
1 2013-10-01 00:00:00.000 cc
2 2013-10-15 00:00:00.000 dd
2 2013-10-15 00:00:00.000 ee
3 2013-10-20 00:00:00.000 ff
(6 行受影响)
------解决方案--------------------
create table #t(s_time datetime,na varchar(20))
insert #t
select '2013-10-1','aa'
union all
select '2013-10-1','bb'
union all
select '2013-10-1','cc'
union all
select '2013-10-15','dd'
union all
select '2013-10-15','ee'
union all
select '2013-10-20','ff'
SELECT DENSE_RANK() OVER(ORDER BY&n
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
