Sybase +如何计算特定组的序列号

作者: 哈哈哈哈
发布时间: 2024-12-11 04:39:18 (15天前)
转自：

2 条回复

0#
回复此人
不浪漫 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 您可以通过如下多步骤处理来实现这一点（我没有测试它，但你会得到这个想法）。假设你的表名为't'。 </p> <pre> <code> select your_date, column1, column2, column3, id = identity(9) into #t1 from t order by column2, column3 -- this seems to be the ordering you want? select column2, min(id) as min_id into #t2 from #t1 group by column2 select #t1.* column4 = (#t1.id - #t2.min_id + 1) into #t3 from #t1, #t2 where #t2.column2 = #t1.column2 select ta.*, column5 = case when tb.id is null or tb.column2 <> ta.column2 then ta.column3 else ta.column3 - tb.column3 from #t3 ta, #t1 tb where ta.id *= (tb.id - 1) </code> </pre> </DIV>

编辑

登录后才能参与评论