15+ years into this writing software thing and I just realized the HAVING keyword exists in SQL. Mentioning for benefit of everyone else creating temporary tables for no reason. http://www.postgresqltutorial.com/postgresql-having/ …
-
Show this thread
-
If software were better at error messages, something might have said, at any point in last 15 years, select customer, sum(orders.amount) as ltv left join orders on orders.customer_id = http://customer.id ) where ltv > 1000 <-- news you can use: you wanted to use HAVING here
5 replies 6 retweets 59 likesShow this thread -
This Tweet is unavailable.
Yeah, it does. (Oh the joys of writing SQL over twitter for a hypothetical schema.)
8:29 PM - 24 Jan 2019
0 replies
0 retweets
7 likes
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.