Select nth element of an array

SQL++
1

I want to write a query which always select second value of “trim” from this array. For now i am able to create the query which fetches all the value or trim.
SELECT ARRAY remark.trim for remark IN mn.remarks.internal.remarks.remark END,1) AS VAL FROM bucket AS mn
remarks": {
“internal”: {
“remarks”: {
“remark”: [
{
“trim”: “ABC”
},
{
“type”: “ABC”,
“cd”: “SUPER”,
“trim”: “false”
}
]
}
}
},

2

If you know exact position …

SELECT mn.remarks.internal.remarks.remark[1].trim
FROM  `bucket`  AS mn;

If you want by condition and by position

   SELECT  (ARRAY v.trim FOR v IN mn.remarks.internal.remarks.remark WHEN v.trim IS NOT NULL END)[1]
    FROM  `bucket`  AS mn;

OR

   SELECT   (SELECT r.trim FROM mn.remarks.internal.remarks.remark AS r WHERE ......)[1]
    FROM  `bucket`  AS mn;
3

Thanks @vsr1 . It really helps