且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SQL在日期范围之间

更新时间:2023-01-29 16:41:17

尝试:

HAVING rtam.dbo.wfm_process_instance.LOCAL_USER_START_TIME 
  >= CONVERT(DATE, MIN(rtam.dbo.gnr_tbl_72_type.LOCAL_COL_113)) 
AND rtam.dbo.wfm_process_instance.LOCAL_USER_START_TIME 
  < DATEADD(DAY, 1, CONVERT(DATE, MAX(rtam.dbo.gnr_tbl_72_type.LOCAL_COL_113))

您可能还会考虑使用别名,这样就不必在代码中重复使用冗长且容易出错的引用,例如rtam.dbo.wfm_process_instance.

You might also think about using aliases so that you don't have to repeat lengthy and error-prone references like rtam.dbo.wfm_process_instance all over your code.