ryantuck/sql-tricks.md

Created July 28, 2016 14:58

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ryantuck/33022660f2fc51f8591272e226cf82bb.js"></script>
Save ryantuck/33022660f2fc51f8591272e226cf82bb to your computer and use it in GitHub Desktop.

some helpful sql tricks

Raw

find any rows where multiple ids exist:

select
  *
from
  my_table
where
  id in (
    select
      id
    from
      my_table
    group by id
    having count(*) > 1
  )

Select an option