Skip to content

Instantly share code, notes, and snippets.

@gmyrianthous

gmyrianthous/select_distinct_w_col.sql

Created September 4, 2022 13:37
Show Gist options
  • Save gmyrianthous/a6db6ea9cffa5e72506ccb9ae1297331 to your computer and use it in GitHub Desktop.
Save gmyrianthous/a6db6ea9cffa5e72506ccb9ae1297331 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select_distinct_w_col.sql
SELECT DISTINCT(customer_id), store_id
FROM rental_example;
/*
|customer_id|store_id|
|-----------|--------|
| 100 | 4 |
| 100 | 6 |
| 58 | 2 |
*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment