查询符合指定时间段的记录

样例数据准备

查询要求：查询日期在每日07:30到10:00之间的所有日期的数据。

CREATE TABLE EXAM (
  OPDT DATETIME,
  SM   VARCHAR(20)
)
GO
WITH EX (opdt,SM) AS
(
  select '2019-02-01 07:29:59','不符' union all
  select '2019-02-01 07:30:00','符合' union all
  select '2019-02-01 07:30:01','符合' union all
  select '2019-02-01 09:59:59','符合' union all
  select '2019-02-01 10:00:00','符合' union all
  select '2019-02-01 10:00:01','不符' union all
  select '2019-02-02 07:29:59','不符' union all
  select '2019-02-02 07:30:00','符合' union all
  select '2019-02-02 07:30:01','符合' union all
  select '2019-02-02 09:59:59','符合' union all
  select '2019-02-02 10:00:00','符合' union all
  select '2019-02-02 10:00:01','不符' union all
  select '2019-12-01 07:29:59','不符' union a