/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 vote148 views1 answer
Sql server on mac m1
SQL
0 vote157 views1 answer
Load data infile mariadb slow
SQL
0 vote151 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote142 views1 answer
Sql shell psql cannot enter password
SQL
0 vote131 views1 answer
Mariadb maximum left join
SQL
2 votes144 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
2 votes182 views1 answer
Orcale index size
SQL
0 vote233 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote136 views1 answer
What is metadata in sql
SQL
0 vote151 views2 answers
Dbms transaction tutorialspoint
SQL