Try
Type your query or get one at random
1
group(suppliers, [:city], :suppliers, allbut: true)
+--------+----------------------------+ | :city | :suppliers | +--------+----------------------------+ | London | +------+-------+---------+ | | | | :sid | :name | :status | | | | +------+-------+---------+ | | | | S1 | Smith | 20 | | | | | S4 | Clark | 20 | | | | +------+-------+---------+ | | Paris | +------+-------+---------+ | | | | :sid | :name | :status | | | | +------+-------+---------+ | | | | S2 | Jones | 10 | | | | | S3 | Blake | 30 | | | | +------+-------+---------+ | | Athens | +------+-------+---------+ | | | | :sid | :name | :status | | | | +------+-------+---------+ | | | | S5 | Adams | 30 | | | | +------+-------+---------+ | +--------+----------------------------+