/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 vote210 views1 answer
Renommer base sql
SQL
3 votes214 views1 answer
Laravel paginate raw sql
SQL
0 vote223 views1 answer
Mysql error codeigniter
SQL
2 votes190 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
23 votes196 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote204 views1 answer
Mysql select where field is a value
SQL
1 vote391 views2 answers
Coderbyte sql solutions
SQL
0 vote196 views1 answer
Jdbc sql connection string
SQL
0 vote194 views2 answers
MySQL top percent
SQL
0 vote215 views1 answer
SQL server datetime compare
SQL