Skip to content

Instantly share code, notes, and snippets.

@kyogesh
Created July 22, 2015 09:47
Show Gist options
  • Save kyogesh/fcb88c72f88d19ca0a39 to your computer and use it in GitHub Desktop.
Save kyogesh/fcb88c72f88d19ca0a39 to your computer and use it in GitHub Desktop.
workbooks=# select distinct(standard_term.term_id) from student_major_term, standard_term where student_id='334244614' and standard_term.term_id=student_major_term.term_id and not period_type='Summer';
term_id
---------
199808
199901
199908
200001
200008
200401
200901
(7 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment