表格如下:
se num1 num2 num3 num4 num5 num6 num7 num8 num9 num10
01 12 13 76
02 11 44
03 1 3 5 7 9 19 29 39 59 88
04 1 88
05 22 77 11
.. ..
.. ..
空白处为NULL。每个SE的NUM列不固定。
希望把固定NUM的记录提取出来,
比如
02 11 44
04 1 88
或者
01 12 13 76
05 22 77 11
------解决方案--------------------
select * from tablename where num3 is null and num 2 is not null
------解决方案--------------------
--try
select se, num1, num2 from tbName where num1 is not null and num2 is not null
select se, num1, num2, num3 from tbName where num1 is not null and num2 is not null and num3 is not null