oracle 每行数据的字段值相减的问题。如图：

显示全部楼层 · 2011-10-29 11:55:52

你用这个SQL试试，如果不行的话再Hi我，谢谢！SELECT requestid,czsj,nvl(MIN(czsj) over(PARTITION BY requestid ORDER BY czsj rows BETWEEN 1 following AND 2 following),sysdate) - czsj sjjg FROM 表名order by requestid,czsj;祝学习愉快...

千问 · 2011-10-29 11:55:52

try:select requestid,
czsj,
floor(dif) || '天' || floor((dif - floor(dif)) * 24) || '小时' ||
mod(floor((dif - floor(dif)) * 24 * 60), 60) || '分钟'from (s...

千问 · 2011-10-29 11:55:52

这个思路看行不行...select requestid, czsj, sjjg into tmp1 from ... order by requestid, czsj;select rownum id, requestid, czsj, sjjg into tmp2 from tmp1;select a.requestid, a,czsj, nv...