Skip to content

Instantly share code, notes, and snippets.

@Mr--John-Doe

Mr--John-Doe/magicNumbers-done_badly.sql

Created October 29, 2021 08:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Mr--John-Doe/f30ab1cd3866b9f1494f061e5ef312c3 to your computer and use it in GitHub Desktop.
Save Mr--John-Doe/f30ab1cd3866b9f1494f061e5ef312c3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
magicNumbers-done_badly.sql
SELECT Store
, Client
, CASE WHEN client=10 THEN 0 ELSE SALES_GBP END AS SALES
, ...
FROM SOME_TABLE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment