jooq finding lastest value in table

Stormy Salamander answered on October 25, 2020 Popularity 1/10 Helpfulness 1/10

answer jooq finding lastest value in table

jooq finding lastest value in table

Comment

// 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();

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: jooq sql

Link to this answer
Share Copy Link

Contributed on Oct 25 2020

Stormy Salamander

0 Answers Avg Quality 2/10

jooq finding lastest value in table

Contents

More Related Answers

jooq finding lastest value in table

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.