/SQL/Jooq finding lastest value in table

Jooq finding lastest value in table

// Assuming these static imports
import static org.jooq.impl.DSL.*;
import static com.example.generated.Tables.*;

Student t = STUDENT.as("t");
Field<Date> maxDate = max(STUDENT.EVENT_DATE).as("MaxDate");
Table<?> tm = table(select(STUDENT.ID, maxDate)
                   .from(STUDENT)
                   .groupBy(STUDENT.ID)).as("tm");

ctx.select()
   .from(t)
   .join(tm)
   .on(t.ID.eq(tm.field(STUDENT.ID)))
   .and(t.EVENT_DATE.eq(tm.field(maxDate)))
   .fetch();

Source: stackoverflow.com

Similar codes

-1 vote308 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
1 vote312 views1 answer
Loading local data is disabled mysql
SQL
11 votes341 views3 answers
Sql_mode=only_full_group_by
SQL
4 votes333 views1 answer
Group by mysql and concatenate string
SQL
1 vote312 views1 answer
Oracle rolling back transactions
SQL
16 votes321 views2 answers
Oracle ddl
SQL
0 vote303 views2 answers
Mysql disable foreign key checks
SQL
0 vote311 views1 answer
Delete double on SQL with multiple primary keys
SQL
2 votes319 views1 answer
Copy all values of a column to another column in sql in same table
SQL
6 votes332 views2 answers
Postgresql restore from dump
SQL