오라클에서 rownum() partion 사용한 것을 sybase 쿼리로 변환을 할려고 하는데 좀 알려 주세요.
tot0466@nate.com
SELECT
'200735' WEEK,
A.ZBWKEY,
A.ZMATNR,
A.D_PRICE
FROM (
SELECT A.ZMANDT, A.ZMATNR, A.ZBWKEY, A.D_PRICE, A.D_MONTH,
ROW_NUMBER () OVER (PARTITION BY ZMANDT, ZMATNR, ZBWKEY ORDER BY D_MONTH ASC) PL1
FROM (
SELECT A.ZMANDT, A.ZMATNR, A.ZBWKEY,
A.ZVERPR / A.ZPEINH AS D_PRICE,
A.ZLFGJA || A.ZLFMON AS D_MONTH
FROM MQM.AZMMBEWH@IMS_TO_TBW A
WHERE A.ZBWTAR = ' '
AND A.ZBKLAS BETWEEN '3000' AND '3006'
AND A.ZLFGJA || A.ZLFMON >= '200707'
UNION ALL
SELECT A.ZMANDT, A.ZMATNR, A.ZBWKEY,
A.ZVERPR / A.ZPEINH AS D_PRICE,
A.ZLFGJA || A.ZLFMON AS D_MONTH
FROM MQM.AZMMBEW@IMS_TO_TBW A
where A.ZBWTAR = ' '
AND A.ZBKLAS BETWEEN '3000' AND '3006'
) A
) A
WHERE A.PL1 = '1'
|