/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 vote301 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote289 views1 answer
How to check which table has data in mysql
SQL
0 vote276 views1 answer
Soql update query
SQL
0 vote295 views1 answer
Consulta alias con inner join
SQL
0 vote284 views1 answer
Sql select where more than one record exists
SQL
0 vote286 views1 answer
Arithmetic expression in sql
SQL
0 vote276 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote290 views1 answer
Possgress drop if exists view
SQL
0 vote277 views1 answer
How to output a different column name in mysql
SQL
0 vote280 views1 answer
Sql server datetime
SQL