分组序号有关问题
日期：2014-05-17 浏览次数：20546 次
分组序号问题
我想实现相同的clcode、clph 的序号一样
如下例子：
create table #b1(cjdw char(12),yscode char(12),ysph char(12),clcode char(12),clph char(10),id int)
insert into #b1(cjdw,yscode,ysph,clcode,clph) values('000000016952','204100500766','13072+PB','207061800610','X322')
insert into #b1(cjdw,yscode,ysph,clcode,clph) values('000000016952','204100500766','13072-1+PB','207061800610','X322')
insert into #b1(cjdw,yscode,ysph,clcode,clph) values('000000016952','204100500766','13072塑料+PB','207061800610','C222')
000000016952 204100500766 13072+PB 207061800610 X322 1
000000016952 204100500766 13072-1+PB 207061800610 X322 1
000000016952 204100500766 13072??+PB 207061800610 C222 2
------解决方案--------------------
我想实现相同的clcode、clph 的序号一样
如下例子：
create table #b1(cjdw char(12),yscode char(12),ysph char(12),clcode char(12),clph char(10),id int)
insert into #b1(cjdw,yscode,ysph,clcode,clph) values('000000016952','204100500766','13072+PB','207061800610','X322')
insert into #b1(cjdw,yscode,ysph,clcode,clph) values('000000016952','204100500766','13072-1+PB','207061800610','X322')
insert into #b1(cjdw,yscode,ysph,clcode,clph) values('000000016952','204100500766','13072塑料+PB','207061800610','C222')
000000016952 204100500766 13072+PB 207061800610 X322 1
000000016952 204100500766 13072-1+PB 207061800610 X322 1
000000016952 204100500766 13072??+PB 207061800610 C222 2
------解决方案--------------------
select *,DENSE_RANK() over( order by clph desc) as no from #b1
/*
000000016952 204100500766 13072+PB 207061800610 X322 NULL 1
000000016952 204100500766 13072-1+PB 207061800610 X322 NULL 1
000000016952 204100500766 13072塑料+PB 207061800610 C222 NULL 2*/
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
