SQLite多條件查詢?
selectVisitingDate,count(*)拜訪次數(shù),Sum(casewhenIsSendBook=truethen1else0end)送書次數(shù),Sum(casewhenIsSign=truethen1else0end)簽單次數(shù)fromVisitingOrdersgroupbyVisitingDate;
SQLite多條件查詢?
selectVisitingDate,count(*)拜訪次數(shù),Sum(casewhenIsSendBook=truethen1else0end)送書次數(shù),Sum(casewhenIsSign=truethen1else0end)簽單次數(shù)fromVisitingOrdersgroupbyVisitingDate;