SELECT DECODE(TRUNC((ROWNUM-1)/15,0),0,1, TRUNC((ROWNUM-1)/15,0)+1 ) PAGENUM,
data.type, data.loginid, data.work_id, data.goodscode, data.goodsname, data.title,
data.content, data.work_photo
FROM (SELECT '1' type, wk.loginid, wk.work_id, wk.goodscode1 goodscode,
goods.goodsname3 goodsname, wk.title1 title, wk.content1 content,
wk.work_photo1 work_photo
FROM worklog wk, goods3 goods
WHERE wk.loginid = 'aa' AND wk.goodscode1 = goods.goodscode3
UNION
SELECT '2' type, wk.loginid, wk.work_id, wk.goodscode2 goodscode,
goods.goodsname2 goodsname, wk.title2 title, wk.content2 content,
wk.work_photo2 work_photo
FROM worklog wk, goods3 goods
WHERE wk.loginid = 'aa' AND wk.goodscode2 = goods.goodscode3
UNION
SELECT '3' type, wk.loginid, wk.work_id, wk.goodscode3 goodscode,
goods.goodsname2 goodsname, wk.title3 title, wk.content3 content,
wk.work_photo3 work_photo
FROM worklog wk, goods3 goods
WHERE wk.loginid = 'aa' AND wk.goodscode3 = goods.goodscode3) data
ORDER BY data.work_id
) aa
where aa.pagenum = 1

==> Oracle에서는 실행되는데 ms-sql에서는 이 구문을 어떻게 처리해야 하는지 좀 알려주세요..