/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

0 vote143 views1 answer
Replace string in whole database mysql stackoverflow
SQL
1 vote132 views1 answer
Mysql last year
SQL
1 vote258 views3 answers
Create table from existing table in sql
SQL
0 vote186 views1 answer
ORA-01400
SQL
0 vote137 views1 answer
Query params sql insert python f string
SQL
17 votes132 views3 answers
Cast in sql server
SQL
2 votes183 views5 answers
Install postgresql 10 centos 7
SQL
0 vote122 views1 answer
Sql comparison operators
SQL
3 votes140 views1 answer
Oracle undo tablespace schema
SQL
0 vote133 views1 answer
Replace content value from old to new sql
SQL