SQL++ - Array comprehensions

Array comprehensions allow you to build new arrays from existing ones.

In the example on the right we build a new array containing just the children's names for all people that have children.

To run this example, click the button in the top right corner of the code editor.

Code Editor

Output