/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 vote267 views1 answer
Postgresql select fast check no rows
SQL
4 votes276 views1 answer
Mysql query first character
SQL
0 vote302 views1 answer
Mysql faster delete
SQL
0 vote266 views1 answer
Assign value to var in SQL
SQL
0 vote280 views1 answer
Select count concat string sql server
SQL
0 vote282 views1 answer
What does leave do in mysql
SQL
4 votes279 views2 answers
Sql offset
SQL
0 vote292 views1 answer
View t-sql mail configuration
SQL
0 vote266 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote270 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL