Re: Query about Count , Max

[Lukas Eder]

Besides, of course, you can also use the MAX function to get a more accurate
behaviour:

int maxscoreID = create
  .select(GAME_ID.max().add(1).as("MAXSCORE_ID"))
  .from(GAME)
  .fetchOne()
  .getValueAsInteger(0);