如何显示相隔10分钟内创建的记录

Question

如何返回当天在10分钟内创建的记录?我想显示所有创建日期为smalldatetime的项目。

我试过这个，但它不工作:

SELECT NAME,
       TITLE,
       CREATED
FROM   TABLE
WHERE  CREATEDBY = 'Billy'
GROUP  BY NAME,
          TITLE,
          CREATED,
          Datepart(YEAR, CREATED),
          Datepart(MONTH, CREATED),
          Datepart(DAY, CREATED),
          Datepart(HOUR, CREATED),
          ( Datepart(MINUTE, CREATED) / 10 ) 

Answer 1

根据我的理解。试试下面的代码:

SELECT NAME,
       TITLE,
       CREATED
FROM   TABLE
WHERE CreatedBy  = 'Billy'  
AND CREATED BETWEEN DATEADD(MINUTE,-10,GETDATE()) AND GETDATE();