一、統(tǒng)計語句

1、–統(tǒng)計當(dāng)前【>當(dāng)天00點以后的數(shù)據(jù)】

SELECT * FROM 表 WHERE CONVERT(Nvarchar, dateandtime, 111) = CONVERT(Nvarchar, GETDATE(), 111) ORDER BY dateandtime DESC