- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
CREATE OR REPLACE VIEW LOAD_PROMOTIONCATEGORY
AS
SELECT
ROW_NUMBER() OVER (ORDER BY CATEGORY_NAME,SUBCATEGORYNAME ASC) AS PROMOTIONCATEGORYID
, CATEGORY_NAME
, SUBCATEGORYNAME
FROM
(
SELECT
DISTINCT
PROMO_CATEGORY AS CATEGORY_NAME
, PROMO_SUBCATEGORY AS SUBCATEGORYNAME
FROM
LIY26.LI_PROMOTIONS
) PROMO