Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT orderid,
- orderdate,
- case
- when shipdate IS NULL THEN shipdate = 'Not Shipped'
- ELSE 'shipped'
- END shipstatus
- FROM orders
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement