Re: How to do the SELECT?

From: Pierre Q.T. Nguyen <pqtn_at_videotron.ca>
Date: Fri, 23 Apr 1999 23:23:26 -0400
Message-ID: <vPaU2.730$cy2.28982@weber.videotron.net>

Sorry for the garbage (2nd sql), I forgot to remove my testing sql...

Pierre Q.T. Nguyen a écrit dans le message ...
>SELECT * FROM my_table
> WHERE odr_no IN
> (SELECT col_1 FROM
> (SELECT odr_no col_1, SUM(pay_rate) col_2 FROM my_table
> GROUP BY odr_no)
> WHERE col_2 = 100);
>
>select * from contrat
>where code_org_2 in
>(select aa from
>(select code_org_2 aa,sum(taux_majoration_reg_eloignee) bb from contrat
>group by code_org_2)
>where bb>80)
>
Received on Fri Apr 23 1999 - 22:23:26 CDT