代码应 Select "数字"值为最小的行. 如果存在"UNIQUE_1",其中"UNIQUE_2"!=MIN,则 Select "Numbers"值为Max的列.
当前代码:
select T1.Unique_1,
T1.Unique_2,
Case WHEN T2.MIN_Number is not NULL then T2.MIN_Number ELSE T3.MAX_Number end as Number from Table_1 as T1 LEFT JOIN (
SELECT Unique_1,
MIN(Number) as MIN_Number
From Table_1 WHERE Unique_2 = 'MIN'
GROUP BY Unique_1) AS T2 ON T1.Unique_1 = T2.Unique_1 LEFT JOIN(
SELECT Unique_1,
MAX(Number) as MAX_Number
From Table_1 WHERE Unique_2 = 'MAX'
GROUP BY Unique_1) AS T3 ON T1.Unique_1 = T3.Unique_1
希望我已经清楚地描述了这个问题.
另外,谢谢您的帮助和建议.