Comments by Hitesh Chavada (Top 1 by date)

pl check update query

Select * from ABC where Col2=1 and Col1 not in (select Col1 from ABC where Col2 != 1)