/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 vote221 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote222 views1 answer
Postgresql select fast check no rows
SQL
0 vote233 views1 answer
Mysql get date diff in months
SQL
-1 vote247 views1 answer
Select first rows postgresql
SQL
8 votes238 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote270 views2 answers
Sql query print strings and int
SQL
1 vote256 views3 answers
Postgresql get difference between two dates
SQL
0 vote213 views1 answer
Mod function example
SQL
24 votes223 views5 answers
Sql server insert into select
SQL
3 votes234 views2 answers
Mysql import gz
SQL