Walmart Global Tech interview question

How to get a subarray from an array in SQL.