求一条语句
数据结构:
name shuxing date
lixiao 0(IPV6) 2011-01-01
lixiao 0(IPV4) 2011-01-01
lixiao 0 2011-01-01
susan 20(IPV6) 2011-01-01
susan 20(IPV4) 2011-01-01
susan 20 2011-01-01
sz 0+max(ss-2000)(IPV6) 2011-01-01
sz 0+max(ss-2000)(IPV4) 2011-01-01
sz 0+max(ss-2000) 2011-01-01
如何删除日期为2011-01-01号的,且shuxing的值里不包含(IPV6),(IPV4)的记录,我要的结果是:
name shuxing date
lixiao 0(IPV6) 2011-01-01
lixiao 0(IPV4) 2011-01-01
susan 20(IPV6) 2011-01-01
susan 20(IPV4) 2011-01-01
sz 0+max(ss-2000)(IPV6) 2011-01-01
sz 0+max(ss-2000)(IPV4) 2011-01-01