MySQL Forums
Forum List  »  General

MAX value by item
Posted by: Alexandre Salomé
Date: April 03, 2020 02:52PM

Hello

I have a huge data table (15GB) where there are the columns
(1) - “""deviceId""" , simple column that repeat N Times
(2) - """DistanciaTotal""" , that is part of array using the comand """REPLACE(JSON_EXTRACT(A.attributes, '$.totalDistance') ,'.',',') as DistanciaTotal"""

I need take the MAX and MIN values DistanciaTotal by DeviceId

Is there a command that is possible run without overflow the server?

Today I'm doing this by extracting and concatenating in excel, but it's very suffer work

Thanks in advance

Alex

Options: ReplyQuote


Subject
Written By
Posted
MAX value by item
April 03, 2020 02:52PM
April 03, 2020 03:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.