/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

7 votes82 views1 answer
Mysql iif
SQL
3 votes84 views1 answer
Créer une table sql
SQL
0 vote72 views1 answer
Mysql auto increment default value with prefix month and year
SQL
17 votes72 views6 answers
Sql current date
SQL
1 vote92 views1 answer
Sql first day quarter
SQL
1 vote93 views1 answer
SQL Integer devision
SQL
0 vote71 views6 answers
Unique key in sql
SQL
19 votes82 views6 answers
Mysql if null
SQL
0 vote94 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote78 views1 answer
Find most frequent value in SQL column
SQL