/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 vote335 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
1 vote285 views1 answer
Mysql select utc time in eastern time
SQL
0 vote311 views1 answer
Check if database exists sql
SQL
0 vote334 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote307 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote296 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
10 votes324 views1 answer
Oracle dba_dependencies
SQL
0 vote325 views1 answer
SAP Return
SQL
-1 vote358 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote329 views1 answer
Faire une recherche par liste de mot clé sql
SQL