Group By
The GROUP BY
keyword is used to arrange the result into an object containing several arrays with a key based on a columns unique value.
SELECT * FROM table_name GROUP BY column;
Note: JSQL only supports grouping results by a single column.