Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Given the statement:
SELECT { 'key': { 'subkey': 'value' }} AS mycolumn;
Which notations will retrieve the value 'value' from the VARIANT column mycolumn? (Choose two.)
mycolumn
A
mycolumn.key.subkey
B
mycolumn.key:subkey
C
mycolumn:key.subkey
D
mycolumn['key'].subkey
E
mycolumn:key:subkey