{
"orgId": 1,
"orgName":"orgOne"
"empList": [
{
"empId": 1,
"empName":"emp1"
},
{
"empId": 2,
"empName":"emp2"
},
{
"empId": 3,
"empName":"emp3"
}
]
}
{
"orgId": 2,
"orgName":"orgTwo"
"empList": [
{
"empId": 2,
"empName":"emp2"
},
{
"empId": 3,
"empName":"emp3"
}
]
}
Do you want orgId of the empId = 2
SELECT d.orgId
FROM default AS d
WHERE ANY e IN d.empList SATISFIES e.empId = 2 END;
Different need more details.