/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 vote181 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
1 vote184 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
0 vote177 views1 answer
Get employees if not contains in sql
SQL
11 votes193 views2 answers
Having clause in sql
SQL
0 vote197 views1 answer
Learnxinyminutes sql
SQL
12 votes216 views4 answers
How to drop all tables in postgresql
SQL
8 votes177 views3 answers
Postgresql connection string c#
SQL
0 vote183 views1 answer
Hashpass
SQL
1 vote191 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
11 votes198 views3 answers
Python sqlite3 create table if not exists
SQL