一、統(tǒng)計(jì)語句

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

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