Home Forums SQL Server 2005 SQL Server 2005 General Discussion Help reqd for eliminating a similar IDs- Query RE: Help reqd for eliminating a similar IDs- Query

  • April 25, 2008 at 3:11 am

    #807017

    select * from table1 where id not in (select id from table1 where status='rework')