sql 按照日期排序,同一日期自动从1开始编号。答:排序使用分析函数 : row_number() OVER ()SELECT row_number() OVER (partition BY t.trandate ORDER BY t.tranamt) "NO",t.trandate,nvl(t.tranamt,'小计'),DECODE( COUNT(*),'1','', COUNT(*)) "计数",decode(SUM(to_number(t.tranamt)),to_number(t.tranamt),'',SUM(to...
用SQL语句生成新列--排序列(1,2,3,4,5,6,。。)答:顺着你的思路说:现在是按VV1,VV2,VV3,VV4,VV5排序(适用于任意类型的字段):select no= (select count(1) from aaa t where t.vv1<o.vv1 or --一个字段排序到此为止,但把<换成<= t.vv1=o.vv1 and t.vv2<o.vv2 or--两个到此为止,但把最后的<换成<= t.vv1=o.vv1 a...