从你现在的结果到你想要的结果
GROUP BY x.property
然后得到
max()
的
CASE
类似于:
SELECT x.property prop,
max(CASE
WHEN x.rank = 1 THEN
x.customer
END) cust1,
max(CASE
WHEN x.rank = 2 THEN
x.customer
END) cust2,
max(CASE
WHEN x.rank = 3 THEN
x.customer
END) cust3
FROM tbl_custbyproperty c
LEFT JOIN (SELECT DISTINCT
cust_id,
customer,
property,
row_number() OVER (PARTITION BY c.property
ORDER BY c.customer) rank
FROM tbl_custbyproperty) x
ON c.cust_id = x.cust_id
GROUP BY x.property
ORDER BY x.property;
但是,如果你编辑你的问题并发布表格中的
CREATE
声明连同
INSERT
用于获取结果的示例数据的语句。