MAX value by item
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
Subject
Written By
Posted
MAX value by item
April 03, 2020 02:52PM
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.