Skip to content

Instantly share code, notes, and snippets.

@springcome

springcome/QuerydslCoalesce.java

Created November 3, 2015 02:04
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save springcome/e86802e75daa48126712 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save springcome/e86802e75daa48126712 to your computer and use it in GitHub Desktop.
Download ZIP
SQL, nvl
Raw
QuerydslCoalesce.java
-- select nvl(num, 0) from table
QMember member = QMember.member;
Integer num =
select().from(member).uniqueResult(
member.num.max().coalesce(0));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment