/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

5 votes226 views1 answer
How to check nls timestamp format in oracle
SQL
24 votes199 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote263 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote229 views2 answers
Sql server select first day of previous year
SQL
0 vote242 views1 answer
Sql last 3 rows
SQL
1 vote235 views1 answer
Postgresql last element of array
SQL
0 vote238 views1 answer
Mysql drop trigger
SQL
25 votes297 views5 answers
Mysql replace text
SQL
1 vote219 views1 answer
How to delete record sql delphi
SQL
3 votes237 views1 answer
Apex set debug level
SQL