Skip to content

Instantly share code, notes, and snippets.

@Paulescu

Paulescu/one_small_query.sql

Created October 11, 2021 08:14
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Paulescu/bd901a4debf674a8f98b8b467f481d81 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Paulescu/bd901a4debf674a8f98b8b467f481d81 to your computer and use it in GitHub Desktop.
Download ZIP
one_small_query.sql
Raw
one_small_query.sql
-- one small query
SELECT
price,
item,
...
time
FROM
orders_table
WHERE
DAY(time) = '2021-07-20' -- << replace with each of the N days you want to fetch
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment