Skip to content

Instantly share code, notes, and snippets.

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