Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: DISTINCT Values

    Hi Dave, perhaps you mean just the unique rows, in that case try

    select g1,g2,g3,g4
    from mytable
    group by g1,g2,g3,g4
    having count(*)=1;

    July 27, 2006 at 5:15 pm

    #652043

Viewing post 1 (of 1 total)