postgresql how to get min and max value from specific range

Question

I have this table of log finger print attendannce.

and i want to select the table with the result like this.

as you can see, in the mindailylog field, it contains the minumum date of that day, and the maxdailylog field value contains the max value of that day.

Gordon Linoff · Accepted Answer · 2020-06-26 11:26:45Z

1

You can use window functions:

select t.*,
       min(waktuabsen) over (partition by userid, waktuabsen::date),
       max(waktuabsen) over (partition by userid, waktuabsen::date),
from t;

This does the minimum per user_id. If you want the overall minimum, just remove userid from the partition by.

answered Jun 26, 2020 at 11:26

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgresql how to get min and max value from specific range

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related