How to find the minimum value in a postgres sql column which contains jsonb data?
|Added at||2016-12-20 07:12|
I have a table
I need to find the minimum amount for each record of the table and the month that amount belongs to.
What I have tried:
Using jsonb_each function and separating key value pairs and then using min function.But still I cant get the month it belongs to.
How can this be achieved?