/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 vote123 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote117 views2 answers
Sql use not in
SQL
16 votes135 views5 answers
Select last row in sql
SQL
1 vote136 views1 answer
Trim leading zeros in sql
SQL
5 votes118 views1 answer
Mysql count newlines in field
SQL
1 vote125 views1 answer
Dropping a constraint in ms sql
SQL
0 vote140 views1 answer
Mysql date without time
SQL
0 vote124 views1 answer
Partitioning in oracle-base
SQL
0 vote125 views1 answer
How to get button for every record from mysql
SQL
1 vote133 views2 answers
How to combine 2 tables in MySQL
SQL