Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dl8R4-0003C5-94 for pgsql-performance@arkaria.postgresql.org; Fri, 25 Aug 2017 06:49:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dl8R2-0006gI-OT for pgsql-performance@arkaria.postgresql.org; Fri, 25 Aug 2017 06:49:40 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dl8R1-0006bN-TM for pgsql-performance@postgresql.org; Fri, 25 Aug 2017 06:49:40 +0000 Received: from mxgate02.infotech-enterprises.com ([110.76.160.160] helo=mxgate02.cyient.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dl8Qs-0001zb-Jy for pgsql-performance@postgresql.org; Fri, 25 Aug 2017 06:49:37 +0000 X-IronPort-AV: E=Sophos;i="5.41,424,1498501800"; d="scan'208,217";a="1230588" Received: from unknown (HELO CYMADFPASMTP) ([172.17.1.107]) by mxgate02.cyient.com with ESMTP; 25 Aug 2017 12:19:36 +0530 Received: from CYMADFPASMTP.CYIENT.COM (CYMADFPASMTP.CYIENT.COM [127.0.0.1]) by CYMADFPASMTP.CYIENT.COM (Service) with ESMTP id CF411C11CF0A for ; Fri, 25 Aug 2017 13:16:50 +0300 (IDT) Received: from CYINMBX5.CORP.CYIENT.COM (unknown [172.17.4.165]) by CYMADFPASMTP.CYIENT.COM (Service) with ESMTP id BD278C11CF03 for ; Fri, 25 Aug 2017 13:16:50 +0300 (IDT) Received: from CYINMBX4.CORP.CYIENT.COM (172.17.4.164) by CYINMBX5.CORP.CYIENT.COM (172.17.4.165) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.544.27; Fri, 25 Aug 2017 12:19:07 +0530 Received: from CYINMBX4.CORP.CYIENT.COM ([fe80::7d7a:c752:6561:9895]) by CYINMBX4.CORP.CYIENT.COM ([fe80::7d7a:c752:6561:9895%19]) with mapi id 15.01.0544.027; Fri, 25 Aug 2017 12:19:07 +0530 From: Daulat Ram To: "pgsql-performance@postgresql.org" Subject: Re: Hi Thread-Topic: Hi Thread-Index: AdK0Hn5c1i8HeoH5S9e3nSKkBtafcBpT5OMg Date: Fri, 25 Aug 2017 06:49:07 +0000 Message-ID: <8476a0511c074ddd9eaf15a3eb2e71ce@cyient.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.17.4.81] Content-Type: multipart/alternative; boundary="_000_8476a0511c074ddd9eaf15a3eb2e71cecyientcom_" MIME-Version: 1.0 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --_000_8476a0511c074ddd9eaf15a3eb2e71cecyientcom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello, Would I request to help me on this query. SELECT 'Inspection Completed' as "ALL Status" ,COUNT(*) as "Number of Count= " FROM ud_document WHERE status =3D 'Inspection Completed' union SELECT 'Pe= nding', COUNT(*) FROM ud_document WHERE status =3D 'Pending' union SELECT '= Approved', COUNT(*) FROM ud_document WHERE status =3D 'Approved' union SELE= CT 'Rejected', COUNT(*) FROM ud_document WHERE status =3D 'Rejected' union = SELECT 'Payment Due',count(*) from ud_document where payment_status =3D 'Pa= yment Due' union SELECT 'Payment Done' ,count(*) from ud_document where pay= ment_status =3D 'Payment Done' And now I want to exclude the uniqueid=3D '201708141701018' from the above = query. how it can be ??? Regards, Daulat ________________________________ DISCLAIMER: This email message is for the sole use of the intended recipient(s) and may= contain confidential and privileged information. Any unauthorized review, = use, disclosure or distribution is prohibited. If you are not the intended = recipient, please contact the sender by reply email and destroy all copies = of the original message. Check all attachments for viruses before opening t= hem. All views or opinions presented in this e-mail are those of the author= and may not reflect the opinion of Cyient or those of our affiliates. --_000_8476a0511c074ddd9eaf15a3eb2e71cecyientcom_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello,

 

Would I request to hel= p me on this query.

 

SELECT 'Inspection Com= pleted' as "ALL Status" ,COUNT(*) as "Number of Count" = FROM ud_document WHERE status =3D 'Inspection Completed' union SELECT 'Pend= ing', COUNT(*) FROM ud_document WHERE status =3D 'Pending' union SELECT 'Approved', COUNT(*) FROM ud_document WHERE status =3D 'Approved' u= nion SELECT 'Rejected', COUNT(*) FROM ud_document WHERE status =3D 'Rejecte= d' union SELECT 'Payment Due',count(*) from ud_document where payment_statu= s =3D 'Payment Due' union SELECT 'Payment Done' ,count(*) from ud_document where payment_status =3D 'Payment Done'&n= bsp;

 

And now I want to excl= ude the uniqueid=3D '201708141701018' from the above query. how it can be ?= ??

 

 

Regards,

Daulat



DISCLAIMER:

This email message is for the sole use of the intended recipient(s) and may= contain confidential and privileged information. Any unauthorized review, = use, disclosure or distribution is prohibited. If you are not the intended = recipient, please contact the sender by reply email and destroy all copies of the original message. Check all a= ttachments for viruses before opening them. All views or opinions presented= in this e-mail are those of the author and may not reflect the opinion of = Cyient or those of our affiliates.
 --_000_8476a0511c074ddd9eaf15a3eb2e71cecyientcom_--