/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 vote331 views1 answer
Mysql text to decimal
SQL
5 votes298 views1 answer
Oracle get foreign keys on table
SQL
1 vote296 views1 answer
Oracle convert run duration to number
SQL
0 vote344 views2 answers
Sql unique
SQL
1 vote323 views2 answers
Grab part of a string sql
SQL
0 vote303 views3 answers
Sql server import json
SQL
1 vote322 views2 answers
Foreign key set 0
SQL
0 vote315 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote310 views1 answer
What is between keyword used for
SQL
4 votes293 views4 answers
Update select mysql
SQL