/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 vote234 views1 answer
Full text index mysql
SQL
0 vote272 views1 answer
Sql count more than 1
SQL
5 votes279 views2 answers
To date oracle
SQL
2 votes280 views1 answer
Mysql select default if null
SQL
0 vote254 views1 answer
Sql query for getting data with join and count
SQL
0 vote288 views1 answer
Compare field sql server
SQL
0 vote263 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
6 votes280 views4 answers
Mysql group by month
SQL
12 votes267 views2 answers
Delete entries in postgresql
SQL
1 vote293 views2 answers
Sql split string by space
SQL