SELECT V.WORK_NO, MOD(ROWNUM, 3) AS ROWNO
FROM PM_VM_WORK_NO V
WHERE V.CORP_CD = '0001'
AND V.LANGUAGE_DIV = '18'
AND V.RPT_WORK_NO = 'AA000001T'
FROM PM_VM_WORK_NO V
WHERE V.CORP_CD = '0001'
AND V.LANGUAGE_DIV = '18'
AND V.RPT_WORK_NO = 'AA000001T'
decode(mod(rownum,3),2,ename,null) as col2,
decode(mod(rownum,3),0,ename,null) as col3
from
emp
满足你要求?
MAX(decode(t.rn,1,t.ename,null)) as col1,
MAX(decode(t.rn,2,t.ename,null)) as col2,
MAX(decode(t.rn,0,t.ename,null)) as col3
from
(select ename,mod(rownum,3) rn ,ceil(rownum/3) as id from emp) t
group by t.idSMITH ALLEN WARD
JONES MARTIN BLAKE
CLARK SCOTT KING
TURNER ADAMS JAMES
FORD MILLER 杨
liping YA_PING 杨平