/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 vote280 views1 answer
Postgresql delete limit
SQL
0 vote284 views1 answer
Create boolean column in MySQL with false as default value?
SQL
0 vote257 views1 answer
Fill up postgres db
SQL
0 vote311 views1 answer
Download sql file of countries names
SQL
1 vote256 views1 answer
Set statistics on in ssms
SQL
3 votes252 views1 answer
MySQL DELETE JOIN
SQL
2 votes296 views2 answers
Create table mysql integer NOT null
SQL
7 votes275 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote267 views1 answer
Sql server datetime to string
SQL
0 vote267 views1 answer
Mysql vs sql server performance benchmark
SQL