Re: How to do the SELECT?

Violin wrote
> I want to select where SUM(PAY_RATE) = 100

    select odr_nr, pay_rate, ...
    from my_table
    where odr_nr in

        ( select odr_nr
          from my_table
          group by odr_nr
          having sum(pay_rate) = 100
        );

Arjan. Received on Sat Apr 24 1999 - 06:25:30 CDT