Peter.Liao

沒什麼了不起的文章，只有一些簡單的筆記

2019-05-02

將子查詢的結果當一個column

  • 47
  • 0

將子查詢的結果當一個column

select  top 1 
(select count(*) from tableName
where CONVERT(varchar , CreateDate, 111) = CONVERT(varchar , '2019/04/30' , 111)	
And ColumnX = 'X') as a,
(select count(*) from tableName 
where CONVERT(varchar , CreateDate, 111) = CONVERT(varchar , '2019/04/30' , 111)	
And ColumnX = 'X' and  ColumnY = 'Y' ) as b
from tableName