sql查询时,where条件后即有and和or,要使用括号将需要区分的括起来。
where set_id = 11 and (year1 is null or year2 is null or year3 is null or year4 is null or year5 is null)
sql查询时,where条件后即有and和or,要使用括号将需要区分的括起来。
where set_id = 11 and (year1 is null or year2 is null or year3 is null or year4 is null or year5 is null)