4 ms·
The very next ask will be "order the zipcodes by number of customers" at which point you'll be back to aggregations, which is where you should have started
by mbb70 11mo ago
The very next ask will be "order the zipcodes by number of customers" at which point you'll be back to aggregations, which is where you should have started
- majormajor 11mo agoHere we start to get close to analytics sql vs application sql, and I think that's a whole separate beast itself with different patterns and anti-patterns.
- bandrami 11mo agoAh, yeah, you beat me to it. I do reporting, not applications.
- bandrami 11mo agoI do reporting, not application development. If somebody wants to know different information I'd write a different query.
- sql_nitpicker 11mo agodistinct seems like an aggregation to me
- deleted 11mo ago[deleted]
- edoceo 11mo agocount(id) group by post_code order by 1
- kristjansson 11mo agoWhole seconds will have been wasted!
- wvbdmp 11mo agoAnti-Patterns You Should Avoid: overengineering for potential future requirements. Are there real-life cases where you should design with the future in mind? Yes. Are there real-life cases where DISTINCT is the best choice by whatever metric you prioritize at the time? Also yes.
- RHSeeger 11mo ago> Are there real-life cases where DISTINCT is the best choice by whatever metric you prioritize at the time Indeed, along that line, I would say that DISTINCT can be used to convey intent... and doing that in code is important. - I want to know the zipcodes we have customers in - DISTINCT - I want to know how many customers we have in each zipcode - aggregates Can you do the first with the second? Sure.. but the first makes it clear what your goal is.
- dleeftink 11mo agoPartly in jest, but maybe we need a NON-DISTINCT signaller to convey the inverse and return duplicate values only. SOMEWHAT-DISTINCT with a fuzzy threshold would also be useful.
- RHSeeger 11mo agoI hear you. It's not all _that_ uncommon for me to query for "things with more than one instance". Although, to be fair, it's more common for me to that when grep/sort/uniqing logs on the command line.