我想在下面的sample.The中检索数据,下面的SQL将返回两条记录。SELECT -1 AS NUMWHERE COMP_CODE = 'TEST' OR SHFT_CODE= 'WK_PH') AND RSRV_DATE_1 BETWEEN @TR_FR AND @TR_TO
AND EMPE_ID =语
我已经创建了Mysql函数,它给出的结果是整型或空值。它适用于所有值。但是当这个查询作为子查询添加时,比如where id in from hotel_season_detailhsd where '2019-04-26' BETWEEN hsd.season_fromdate and hsd.season_