Skip to content

Instantly share code, notes, and snippets.

@3v0k4

3v0k4/select_id_title_genre_from_films_group_by_id.sql

Last active December 21, 2019 00:02
Show Gist options
  • Save 3v0k4/26a0f60e56e3ddff7cc67c05be3111cb to your computer and use it in GitHub Desktop.
Save 3v0k4/26a0f60e56e3ddff7cc67c05be3111cb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select_id_title_genre_from_films_group_by_id.sql
=> SELECT id, title, genre FROM films GROUP BY id;
id | title | genre
----+-------------------+----------
3 | Arrival | scifi
1 | Blade Runner 2049 | thriller
2 | Inception | thriller
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment