fork download
copy 
  1. SELECT
  2.   orders.id                                                    AS id,
  3.   string_agg(ordered_items.item_id :: CHARACTER VARYING, ', ') AS items
  4. FROM orders
  5.   INNER JOIN ordered_items
  6.     ON orders.id = ordered_items.order_id
  7. GROUP BY orders.id;
Success #stdin #stdout 0.02s 23316KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
SELECT
  orders.id                                                    AS id,
  string_agg(ordered_items.item_id :: CHARACTER VARYING, ', ') AS items
FROM orders
  INNER JOIN ordered_items
    ON orders.id = ordered_items.order_id
GROUP BY orders.id;
https://ideone.com/AVv3Y8
language:
PHP (php 7.3.5)
created:
7 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!