/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 vote385 views2 answers
Sql server backup table
SQL
3 votes332 views1 answer
Oracle apex message quit website
SQL
1 vote507 views3 answers
Uninstall postgresql mac
SQL
2 votes343 views1 answer
Brew start postgres manual
SQL
0 vote350 views1 answer
Sqlplus change user
SQL
-3 votes441 views8 answers
Sql to c# linq converter online
SQL
0 vote384 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote343 views1 answer
How to convert DateTime to VarChar SQL
SQL
1 vote336 views1 answer
Oracle sql create or replace view
SQL
4 votes366 views1 answer
Id increment ms sql server
SQL