You can use jq in-built function max(), max_by() and min(), min_by() to get the maximum and minimum values in JSON data using JQ. Below is an example for your reference –
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
cat << EOF > data.json [ { "id": 300, "name": "cloudaffaire", "did": [2,1,3,7,4,6,5] }, { "name": "debjeet", "id": 100 }, { "name": "chandrima", "id": 200 } ] EOF cat data.json | jq '.[0].did | max' ## returns 7 cat data.json | jq '.[0].did | min' ## returns 1 cat data.json | jq 'max_by(.id)' ## returns output with id having max value cat data.json | jq 'min_by(.id)' ## returns output with id having min value |