blob: 235e70d85936cae0046b0e421ffbcb3b76db5d2b (
plain) (
blame)
1
2
3
4
5
6
7
|
/* syntax version 1 */
/* postgres can not */
$data = SELECT "a,b,c,d" AS a, "e,f,g,h" AS b, "x" AS c;
SELECT bb,count(*) as count FROM $data FLATTEN BY (String::SplitToList(a, ",") as a, String::SplitToList(b, ",") as bb) GROUP BY bb ORDER BY bb,count;
|
