Skip to content

Instantly share code, notes, and snippets.

@HenryAtWealthfront

HenryAtWealthfront/better_query2.sql

Created May 23, 2023 21:12
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 HenryAtWealthfront/edd4aefbe841b78ff9945a321879b230 to your computer and use it in GitHub Desktop.
Save HenryAtWealthfront/edd4aefbe841b78ff9945a321879b230 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
better_query2.sql
SELECT
*
FROM
orders
JOIN
order_allocations
ON orders.id = order_allocations.order_id
WHERE
orders.completed_at > date(now())
AND order_allocations.client_id = 'A'
AND order_allocations.order_id > :yesterdaysId
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment