Post reply

multiple rows joined on different columns

  • December 3, 2005 at 9:54 am

    #88824

    does anyone know how to select (delete) the second of a pair of rows in 1 table that are joined by 2 different columns and ordered by a third?

    e.g. row 1 = a, today, x, y

    row 2 = b, yesterday, z, x

     

    I want to select row 2 (and do that for many millions of other pairs)

  • December 3, 2005 at 12:09 pm

    #607576

    I'm not sure I'm following your question.  Can you post a few rows and show the select statement? 

    If the phone doesn't ring...It's me.

  • December 3, 2005 at 2:42 pm

    #607583

    Please provide DDL and sample data.

    For an explanation, see http://www.aspfaq.com/etiquette.asp?id=5006

    SQL = Scarcely Qualifies as a Language

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply