select PARTNO,rank() over(partition by PARTNO order by SEQUENCE_NO) as SEQUENCE_NO
from tablename
order by PARTNO,SEQUENCE_NO
from tablename
order by PARTNO,SEQUENCE_NO
解决方案 »
- SQL Server 2005 express 安装失败
- 存储过程里读取数据精度的问题
- 求助:关于数据库的格式
- 我想把这些用","隔开的字符找出来并存到一个数组中,请会的帮个忙
- 在一个存储过程中,我想这样set @vSeqValue = exec ('select max(col1)+1 from '+@table_name); 但是报错,请帮忙解决
- delete 删除数据的问题
- 有没有这样的函数
- er建模问题
- 如何从一个.mdf文件中取出其中的存储过程
- 求:生成十六进制样式的客户编号之SQL写法
- 我的分都送完了,但也希望各位大哥帮帮我.
- HELP,求救啊,高手快回我啊!! (在线等待)表的问题
go
update A set SEQUENCE_NO=(select count(*) from TableName where PARTNO=A.PARTNO and id<=A.id) from TableName A
go
alter table tableName deop id
go
declare @C_SEQUENCE_NO varchar(1)
declare @i_no Int
set @i_no = 0
declare cur_Select cursor for
select distinct PARTNO from tableName
bein trans
fetch next from cur_Select into @C_PARTNOdo while @@fetch_status =0
begin set @i_no = @i_no + 1
update SEQUENCE_NO = @i_no + 1 where PARTNO =@C_PARTNO
fetch next from cur_Select into @C_PARTNOend
close cur_Select
deallocate cur_Selectcommit trans