Skip to content

Instantly share code, notes, and snippets.

@Eugeny
Created May 6, 2011 11:06
Show Gist options
  • Save Eugeny/958765 to your computer and use it in GitHub Desktop.
Save Eugeny/958765 to your computer and use it in GitHub Desktop.
14:05:29,846 DEBUG SQL:111 -
select
distinct student0_.ID as ID3_,
student0_.COURSE as COURSE3_,
student0_.GROUP_NUMBER as GROUP3_3_,
student0_.IS_BUDGET as IS4_3_,
student0_.RECORD_BOOK_N as RECORD5_3_,
student0_.SPECIALITY as SPECIALITY3_,
student0_.STUDENT_ED_TYPE as STUDENT7_3_,
student0_.STUDENT_STATUS as STUDENT8_3_,
student0_.YEAR_OF_ENTERING as YEAR9_3_,
student0_.UNIVERSITY_ID as UNIVERSITY10_3_,
student0_.USER_ID as USER11_3_
from
MAIN.STUDENT student0_
where
cast(student0_.GROUP_NUMBER as varchar(255)) like ?
group by
student0_.GROUP_NUMBER
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment