/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 vote150 views1 answer
Simple project for database
SQL
0 vote161 views1 answer
Limit in access query
SQL
0 vote181 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote156 views1 answer
Postgresql create query
SQL
9 votes154 views4 answers
How to alter table column name in mysql
SQL
2 votes151 views1 answer
Mysql select random id from table
SQL
0 vote162 views1 answer
Postgresql create table default value timestamp
SQL
18 votes147 views4 answers
Foreign key mySql
SQL
0 vote196 views1 answer
Convert rows into columns in oracle
SQL
0 vote155 views1 answer
Mysql pad zeros
SQL