Is there an IF statement that I can use in an Oracle SQL statement.
Example:
SELECT
item,
description,
Week1 = If orderdate between A and B Then qty, else 0
Week2 = If orderdate between C and D then qty, else 0
and so forth...
FROM
orders;
Any help would be greatly appreciated...
Thank you