Can any sql guru take a look at this problem?
I try to select number array from a JSON object, but have no idea how to do it.

https://stackoverflow.com/questions...

You got an answer.....an actual answer in SO.....wooooow

Yeap. It was faster than Tesla 😎

My colleague had a solution which converts the integer array to a CSV string from client side, and then parses it in SQL. It takes more than more line to do (full screen length), which is absolutely insane. They do the same thing for years and never doubted why.

Can't help you on answer but can give you an upvote on your question.

@py2js Got an perfect answer right after I posted. Thank you for your generosity