python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - min

Django how to get the value of other fields in annotate Max？

I want to get the value of other fields('status') in annotate Max or Min，how can I do it？ DB user time status name_a 2022-01-03 11:23:40.000000 3 name_a 2022-01-03 17:56:41.000000 4 name_a...
test-img

yuong

django

filter

max

min

annotate

Votes: 0

Answers: 1

Latest Answer

You can use Attendance.objects.order_by('time').first().status - get status of min date. And use Attendance.objects.order_by('time').last().status - get status of max date.
test-img

Airat Ahunov

Max&min of a sinus DF ; TypeError: 'function' object does not support item assignment

I try to get the min & max spots of a Dataframe that is sinusoidal. The Frequency is in 400er steps. I wanted to define the function amplitude and collect the data in an array. Amp1 is an abs max ...
test-img

Philipp s

python

for-loop

max

min

amplitude

Votes: 0

Answers: 0

Take oldest record in a set of rows

So, I have this problem, I have this set of records in a table TemperatureID CastingID TemperatureDateTime TemperatureValue 1421294 1073513 2021-01-07 11:53:00.000 1648 1421295 1073513 2021-...
test-img

Stefano Buzzoni

sql

sql-server

grouping

min

Votes: 0

Answers: 1

Latest Answer

You can try this, SELECT * FROM ( SELECT * , RANK() OVER (PARTITION BY CastingID ORDER BY TemperatureDateTime ASC) RN FROM TABLE_1 ) A WHERE RN = 1;
test-img

Abishek VK

PostgreSQL: Selecting second lowest value for each unique race?

I have the following table using PostgreSQL ID racedate racetime racename track horsename pos weight 1 2022-1-1 01:00 race1 test MrEd 1 56 2 2022-1-1 01:00 race1 test SeaBiscuit 2 54 3 202...
test-img

Jay Jericho

sql

postgresql

min

Votes: 0

Answers: 1

Latest Answer

Use DENSE_RANK here: WITH cte AS ( SELECT r.id, h.weight, h.horsename, r.racename, r.racedate, r.track, DENSE_RANK() OVER (PARTITION BY r.racename ORDER BY h.weight) drnk FROM races...
test-img

Tim Biegeleisen

Posts

Questions

Blogs

Jobs