this query returns multiple rows in json format. I want the result of this query to be a single row of json in format .... [{..},{..}]
SELECT
json_object ('ANSWR_SEQ' value ANSWR_SEQ,
'EFF_START_DT' value EFF_START_DT,
'ANSWR_ID' value ANSWR_ID,
'ANSWR_STR' value ANSWR_STR,
'ANSWR_STS_KEY' value ANSWR_STS_KEY,
'QST_SEQ' value QST_SEQ,
'ANSWR_SCORE' value ANSWR_SCORE,
'CRTD_BY' value CRTD_BY,
'CRTD_DT' value CRTD_DT,
'LAST_UPD_BY' value LAST_UPD_BY,
'LAST_UPD_DT' value LAST_UPD_DT,
'DEL_FLG' value case when DEL_FLG=1 then 'true' when DEL_FLG=0 then 'false' end ,
'EFF_END_DT' value EFF_END_DT,
'CRNT_REC_FLG' value case when CRNT_REC_FLG =1 then 'true' when CRNT_REC_FLG =0 then 'false' end)
FROM mw_answr