Find the records and delete it

Transact-SQL
1

Hi Peeps,
I am following condition of records in the table.
Spid Syncid
1234 1234
1234
1234

I want my sql select to only return row 2 and 3 only.

How can I achieve it?

Please advise.

2

If this get you the result you expect:

select *
  from yourtable as t
 where spid=1234
   and syncid is null
;

then this will delete them:

delete t
  from yourtable as t
 where spid=1234
   and syncid is null
;
3

Thanks but there are not just 3 rows there are more than 100k

4 
select *
  from yourtable as t
 where syncid is null
;
5

I'm glad you understand what the O/P wants on such scant information ...

6

Sorry on some rows the spid and syncid would be matching don't need that to come out.

7

Do you have records where both spid and syncid are null?
If so and you want to keep them:

select *
  from yourtable as t
 where syncid is null
   and spid is not null
;