Delete from table1 
where ID=' '
and Name=' '
and Value=' '

或

Delete from table1 
where ID is null
and Name is null
and Value is null