/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 vote276 views1 answer
Sql query to delete row by id
SQL
0 vote291 views1 answer
How to declare variable date in mysql
SQL
36 votes353 views6 answers
Change column data type sql
SQL
1 vote275 views1 answer
Postgresql filter on
SQL
1 vote293 views1 answer
Use of now() in mysql
SQL
0 vote316 views1 answer
Run sql script file and changes db name in this file using c#
SQL
6 votes297 views2 answers
Postgresql restore from dump
SQL
0 vote463 views1 answer
Sql change a colum to unique
SQL
-1 vote233 views2 answers
Datetime sql server week
SQL
1 vote279 views1 answer
Sql select contem uma palavra
SQL