1 2 3 4 5 6 7
# mssql:test let distinct = rel -> (from t = _param.rel | group {t.*} (take 1)) from_text format:json '{ "columns": ["a"], "data": [[1], [2], [2], [3]] }' distinct remove (from_text format:json '{ "columns": ["a"], "data": [[1], [2]] }') sort a