/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 vote200 views1 answer
Mysql 3 months ago
SQL
0 vote218 views1 answer
Hibernate dialect property xml for mysql 8
SQL
9 votes158 views2 answers
Default number in sql
SQL
0 vote176 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
3 votes181 views1 answer
Define REGEXP?
SQL
1 vote171 views1 answer
Tsql random number
SQL
2 votes164 views1 answer
Sqlite show table indexes
SQL
0 vote172 views1 answer
Mysql multiple count
SQL
0 vote192 views2 answers
Coursera spark sql max count
SQL
0 vote178 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL