SQL antipatterns: SELECT DISTINCT
Uli Bethke
The DISTINCT operator The DISTINCT operator is used to eliminate duplicates in a resultset, e.g. we can use it to identify the unique number of customers who made a purchase. We run the following query against the Sample Data provided with Snowflake data cloud platform. SELECT DISTINCT SS_CUSTOMER_SK from "SAMPLE_DATA"."TPCDS_SF10TCL"."STORE_SALES"; 1 SELECT DISTINCT SS_CUSTOMER_SK from ...
Read MoreROAD SAFETY DATA UK
Overview The strategic road network (SRN) is a vital national asset, supporting economic growth, regional development, and employment opportunities across England and the rest of the UK. It connects families, communities and businesses, enriching the lives of many citizens. Billions of miles are traveled on the SRN each year. The vast majority of these are ...
Read MoreFlowHigh [Video]: Visualise, format, optimise and parse your SQL
Contact us if you would like to be part of the private preview of the FlowHigh SQL revolution
Read MoreERA5 variables
Single Level variables Variable Label U10 10m u-component of wind V10 10m v-component of wind D2M 2m dewpoint temperature T2M 2m temperature MSL Mean sea level pressure MWD Mean wave direction MWP Mean wave period SST Sea surface temperature SWH Significant height of combined wind waves and swell SP Surface pressure TP Total precipitation ...
Read More