Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT t.location,
- l.city,
- f.year,
- f.customer FROM loc t,
- location l, father_table f
- WHERE f.number = t.number(+)
- AND f.code = '0001'
- AND f.c_code = '01'
- AND t.location= l.code(+)
- AND t.code IN ('C', 'S')
- AND t.co_code IN ('G', 'V', 'A', 'D')
- AND t.year = '2008'
- ORDER BY l.city, f.year
- SELECT SUM(nvl(t.sale_quantity,0)) sale_quantity
- FROM loc t, father_table f
- WHERE f.number = t.number(+)
- AND f.code = '0001'
- AND f.c_code = '01'
- AND f.year = '2008'
- AND t.code = 'C'
- AND t.location = '1566' <----- EACH ROW'S t.location VALUE
- AND t.co_code IN ('G', 'V', 'A', 'D')
- GROUP BY t.location, t.code, f.year
- SELECT t.location,
- l.city,
- f.year,
- f.customer,
- SUM( NVL( CASE WHEN t.code ='C' THEN t.sale_quantity ELSE 0 END, 0)) sale_quantity
- FROM loc t, location l, father_table f
- WHERE f.number = t.number(+)
- AND f.code = '0001'
- AND f.c_code = '01'
- AND t.location= l.code(+)
- AND t.code IN ('C', 'S')
- AND t.co_code IN ('G', 'V', 'A', 'D')
- AND t.year = '2008'
- GROUP BY t.location, l.city, f.year
- ORDER BY l.city, f.year
Add Comment
Please, Sign In to add comment