dues_id number primary key , 党费表ID
member_id number not null ,人员ID
year_index number not null ,年份
month_1 number ,
month_2 number ,
month_3 number ,
month_4 number ,
month_5 number ,
month_6 number ,
month_7 number ,
month_8 number ,
month_9 number ,
month_10 number ,
month_11 number ,
month_12 number ,
sql不会写 求大神帮忙
------解决思路----------------------
SELECT * FROM tb
WHERE
DECODE(month_1,0,0,1)
------解决思路----------------------
DECODE(month_2,0,0,1)
------解决思路----------------------
DECODE(month_3,0,0,1)
------解决思路----------------------
DECODE(month_4,0,0,1)
------解决思路----------------------
DECODE(month_5,0,0,1)
------解决思路----------------------
DECODE(month_6,0,0,1)
------解决思路----------------------
DECODE(month_7,0,0,1)
------解决思路----------------------
DECODE(month_8,0,0,1)
------解决思路----------------------
DECODE(month_9,0,0,1)
------解决思路----------------------
DECODE(month_10,0,0,1)
------解决思路----------------------
DECODE(month_11,0,0,1)
------解决思路----------------------
DECODE(month_12,0,0,1)
LIKE '%000000%'
------解决思路----------------------
楼上的写法有点问题,如果跨年的就不行了,比如去年8月到今年3月没交,也算超过半年了