SQL 按条件输出最小值~~~~~~~~~~~~~~~~~~~~~~~~~

[苏楠楠]

如图:
希望输出结果是两行数据：
d_Status='T' 的d_CT列最小值
d_Status='B 的d_CT列最小值

[苏楠楠]

快来人

[本人QQ-554433626]

使用min():

SELECT MIN(d_CT)  FROM TABLE WHERE d_Status='T';
SELECT MIN(d_CT)  FROM TABLE WHERE d_Status='B';

MySql:

SELECT d_CT FROM TABLE WHERE d_Status='T' ORDER BY d_CT ASC LIMIT 0,1;
SELECT d_CT FROM TABLE WHERE d_Status='B' ORDER BY d_CT ASC LIMIT 0,1;

sql server:

SELECT  top(1) d_CT FROM TABLE WHERE d_Status='T' ORDER BY d_CT ASC;
SELECT top(1) d_CT FROM TABLE WHERE d_Status='B' ORDER BY d_CT ASC;

[苏楠楠]

引用 2 楼 qq_32661557 的回复:

使用min():

SELECT MIN(d_CT)  FROM TABLE WHERE d_Status='T';
SELECT MIN(d_CT)  FROM TABLE WHERE d_Status='B';

MySql:

SELECT d_CT FROM TABLE WHERE d_Status='T' ORDER BY d_CT ASC LIMIT 0,1;
SELECT d_CT FROM TABLE WHERE d_Status='B' ORDER BY d_CT ASC LIMIT 0,1;

sql server:

SELECT  top(1) d_CT FROM TABLE WHERE d_Status='T' ORDER BY d_CT ASC;
SELECT top(1) d_CT FROM TABLE WHERE d_Status='B' ORDER BY d_CT ASC;

哥哥,我要一条语句搞定！！！

[ilikeff8]

借用一下1楼的代码， 联合一下不就得了 SELECT top(1) d_CT as r FROM TABLE WHERE d_Status='T' ORDER BY d_CT ASC union SELECT top(1) d_CT as r FROM TABLE WHERE d_Status='B' ORDER BY d_CT ASC

[苏楠楠]

还要跟这些条件：where d_PartNo='LFAVK7030-65510-01' and d_Ver ='V1'and d_NM ='MP'

[苏楠楠]

引用 4 楼 ilikeff8 的回复:

借用一下1楼的代码， 联合一下不就得了 SELECT top(1) d_CT as r FROM TABLE WHERE d_Status='T' ORDER BY d_CT ASC union SELECT top(1) d_CT as r FROM TABLE WHERE d_Status='B' ORDER BY d_CT ASC

select [d_Mu],[d_Cust],[d_Model],[d_PartNo],[d_LineBT],[d_Status],[d_CT],[d_UPHC],[d_UPHP],[d_BTBS],[d_LBS],[d_HC],[d_LB],[d_Ver],[d_User],[d_Time] from 这是前面的查询的显示栏位

[苏楠楠]

引用 4 楼 ilikeff8 的回复:

借用一下1楼的代码， 联合一下不就得了 SELECT top(1) d_CT as r FROM TABLE WHERE d_Status='T' ORDER BY d_CT ASC union SELECT top(1) d_CT as r FROM TABLE WHERE d_Status='B' ORDER BY d_CT ASC

这样Union就行不通