sql 按照日期排序,同一日期自动从1开始编号。答:oracle 数据库:排序使用分析函数 : 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...