Skip to content

Instantly share code, notes, and snippets.

@toddlipcon

toddlipcon/gist:7723a92684124a212d8d06839b915a84

Created January 24, 2020 17:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save toddlipcon/7723a92684124a212d8d06839b915a84 to your computer and use it in GitHub Desktop.
Save toddlipcon/7723a92684124a212d8d06839b915a84 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
> select * from foo
name: foo
time f1 tag1 tag2
---- -- ---- ----
1579885717128019698 100 v1 v2
1579885727536934291 200 v1
> select max(f1) from foo group by tag2
name: foo
tags: tag2=
time max
---- ---
1579885727536934291 200
name: foo
tags: tag2=v2
time max
---- ---
1579885717128019698 100
>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment