/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 vote102 views1 answer
Postgres get month name from date
SQL
18 votes107 views4 answers
Mysql current date between two dates
SQL
11 votes106 views5 answers
How to install sqlite3 python
SQL
0 vote111 views1 answer
ORA-13717
SQL
31 votes119 views2 answers
Grant all priviledges to mysql user
SQL
0 vote99 views1 answer
Mysql last 6 months
SQL
8 votes110 views1 answer
Oracle add months to sysdate
SQL
0 vote105 views1 answer
Wp_query raw sql
SQL
11 votes115 views4 answers
Update row in mysql
SQL
0 vote104 views1 answer
Oracle last character of string
SQL