select Id, value 
from @data
where value != 1