/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

2 votes283 views1 answer
How to select first row of database sql
SQL
0 vote301 views1 answer
Dump db only triggers mysql
SQL
0 vote303 views1 answer
Mysql select field if condition
SQL
0 vote292 views2 answers
Mysql add days to date
SQL
1 vote260 views2 answers
Show sql logs in spring boot
SQL
0 vote306 views1 answer
Set default value now() date
SQL
0 vote299 views1 answer
Sql change date format
SQL
0 vote302 views1 answer
Create new schema mysql
SQL
0 vote299 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote297 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL