SQL_多欄位日期BETWEEN用法

  • 48
  • 0

SQL_多欄位日期+BETWEEN用法

不解釋!看以下語法自己活用~

select *  from nss_care_rpt   where
nrp_1000='023' and nrp_1001='1012028'
and nrp_1002+nrp_1003 between convert(datetime,'20190616 23:50') and  convert(datetime,'20190617 11:50')
order by nrp_1002,nrp_1003,nrp_1013