Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    16

    Unanswered: delete those rows where the data in column1 is equal to the data in column in 2

    Hi
    I have to delete those rows where the date in column1 is equal to the date in column in 2
    for eg The data in the table will be as follows
    i have the following data
    name dt1 dt2
    A 08/04/2004 08/04/2004
    B 08/05/2004 08/04/2004
    C 07/04/2004 07/04/2004

    In the above case i need to delete the records A and C as the dates in both the columns in equal
    Can anyone please help me
    Regards
    Shalu

  2. #2
    Join Date
    Sep 2004
    Location
    Bogota, Colombia
    Posts
    5

    Unhappy Try this...

    Is this Sybase ASE?

    I tried this and it worked fine:

    delete T1
    where dt1 = dt2
    go

    Juan

  3. #3
    Join Date
    Aug 2004
    Posts
    18
    In ASA, it would be almost the same:

    DELETE FROM myTable WHERE dt1 = dt2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •