/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 vote146 views1 answer
Calculate age in sql
SQL
0 vote105 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote146 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote144 views1 answer
Postpresql relation not found
SQL
8 votes135 views1 answer
How to remove tables from postgresql
SQL
0 vote153 views1 answer
Postgresql check total storage
SQL
0 vote165 views1 answer
Sqlalchemy query join many to many
SQL
0 vote144 views1 answer
Sql quary intervewi question
SQL
0 vote145 views1 answer
Split string by comma in sql server
SQL
1 vote139 views2 answers
Sql server backup table
SQL