delete query wth a condition

  • Thread starter Thread starter subs
  • Start date Start date
S

subs

ozip dzip consignee shipdate
c f cat 1/2/2008
g f cat 1/2/2008
l t cat 1/2/2008
l1 t cat1 2/3/2008
l1 t cat1 2/3/2008

I want to delete the first two records in this table since they donot
have any other record with SAME dzip ,consignee ,shipdate
but DIFFERENT ozip. On the other hand , the last two
records have another matching record(the third one) which have SAME
dcity,dstate,dzip ,consignee ,shipdate but DIFFERENT
ozip. So my final output should be only last three records. IS THERE
ANY SQL QUERY or Delete Query with a condition.PLS HELP
 
Back
Top