Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 861821336971 for ; Tue, 14 Dec 2010 03:35:34 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 96812-04 for ; Tue, 14 Dec 2010 07:35:26 +0000 (UTC) X-Greylist: delayed 00:16:06.180471 by SQLgrey-1.7.6 Received: from sam.nabble.com (216-139-236-26.aus.us.siteprotect.com [216.139.236.26]) by mail.postgresql.org (Postfix) with ESMTP id 460631337B82 for ; Tue, 14 Dec 2010 03:35:24 -0400 (AST) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.69) (envelope-from ) id 1PSPAK-0005co-54 for pgsql-sql@postgresql.org; Mon, 13 Dec 2010 23:19:16 -0800 Date: Mon, 13 Dec 2010 23:19:16 -0800 (PST) From: emaratiyya To: pgsql-sql@postgresql.org Message-ID: <1292311156150-3304147.post@n5.nabble.com> In-Reply-To: References: Subject: Re: Using count on a join, group by required? MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.216 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RDNS_DYNAMIC=0.982, RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201012/66 X-Sequence-Number: 34902 Hi,Please help me solving this problem. I appreciate..Thankyou. Create the following table and insert few arbitrary records.=20 Product (product_id, product_name, supplier_name, quantity, price_per_unit) You are required to create PL/SQL package that achieves the following functionalities: =E2=80=A2=09Obtaining the product supplier name by using the product_id =E2=80=A2=09Changing the price_per_unit by using the product_id =E2=80=A2=09When changing the price of the product, you have to have PL/SQL= code that keeps the history of the prices. For this functionality you need to create audit table: product_audit(product_id, old_price, new_price, date_of_change= ) =E2=80=A2=09Updating the quantity by using the product_id =E2=80=A2=09Get warning when the product level of stock (quantity) goes bel= ow certain threshold (e.g. 10) --=20 View this message in context: http://postgresql.1045698.n5.nabble.com/Using= -count-on-a-join-group-by-required-tp2471469p3304147.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com.