摘要：
SELECT SUBSTRING(replace(replace(replace(CONVERT(varchar, ScanTime, 120 ),'-',''),' ',''),':',''),9,3) ctime, count(1) num FROM [eschool_1].[dbo].kg_Kaoqin group by SUBSTRING(replace(replace... 阅读全文
摘要：
CREATE TABLE snake (name VARCHAR(10 ),type INT,num INT, ctime DATETIME ) INSERT INTO snake VALUES(' 方便面', 1,10 ,'2015-08-10 16:20:05') INSERT INTO snake VALUES(' 香烟A ', 2,2 ,'2015-08-10 18:21:10') IN... 阅读全文