I need help with the SQL statements here:
I have a table as shown in the picture.
Step 1: I wanted all the records with ds_test_id 209. I did this
SELECT * FROM DESSTEPS where DS_TEST_ID = '209'
Step 2: Now, I want to store the values of DS_DESCRIPTION for DS_TEST_ID='209' in an array in a sequence based on DS_STEP_ORDER.
How can I accomplish the steps 1 and 2 in a single SQL statement?