How to create nested record type in memsql

I want to return a nested record type as out parameter. Which will be consumed by java service to form JSON.
can some one help with how to declare nested record type in memsql.

Hello Rati,

Welcome to MemSQL Forums!

MemSQL has some powerful ways of handling nested JSON data. Please see if our docs can help you in achieving your objectives.

Thanks,