Return-Path: Delivered-To: apmail-jackrabbit-dev-archive@www.apache.org Received: (qmail 66125 invoked from network); 24 Sep 2010 14:56:59 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 24 Sep 2010 14:56:59 -0000 Received: (qmail 67197 invoked by uid 500); 24 Sep 2010 14:56:59 -0000 Delivered-To: apmail-jackrabbit-dev-archive@jackrabbit.apache.org Received: (qmail 66979 invoked by uid 500); 24 Sep 2010 14:56:56 -0000 Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@jackrabbit.apache.org Delivered-To: mailing list dev@jackrabbit.apache.org Delivered-To: moderator for dev@jackrabbit.apache.org Received: (qmail 63626 invoked by uid 99); 24 Sep 2010 14:55:17 -0000 X-ASF-Spam-Status: No, hits=-0.1 required=10.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of Zhendong.Chen@pb.com designates 199.231.49.128 as permitted sender) From: Zhendong Chen To: "dev@jackrabbit.apache.org" Date: Fri, 24 Sep 2010 10:54:05 -0400 Subject: How to remove duplicates query results without 'DISTINCT' in jackrabbit Thread-Topic: How to remove duplicates query results without 'DISTINCT' in jackrabbit Thread-Index: Actb+FWf0rqjPQlhSfyDbXZN/FUGRA== Message-ID: <23AEE71D54A5D343BD05B0CA6A73E833022BDB9D1726@PBI-NAMSG-01.MGDPBI.global.pvt> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-cr-puzzleid: {BC791A86-F6F9-4093-8BD1-0BF6E22A127C} x-cr-hashedpuzzle: NfQ= /xE= CN0r CsD7 C3X+ D7Vr D+Ln Effw EkVH Ghxg Gv9T GzPS HhAE H6O6 IrgV JfNH;1;ZABlAHYAQABqAGEAYwBrAHIAYQBiAGIAaQB0AC4AYQBwAGEAYwBoAGUALgBvAHIAZwA=;Sosha1_v1;7;{BC791A86-F6F9-4093-8BD1-0BF6E22A127C};egBoAGUAbgBkAG8AbgBnAC4AYwBoAGUAbgBAAHAAYgAuAGMAbwBtAA==;Fri, 24 Sep 2010 14:54:05 GMT;SABvAHcAIAB0AG8AIAByAGUAbQBvAHYAZQAgAGQAdQBwAGwAaQBjAGEAdABlAHMAIABxAHUAZQByAHkAIAByAGUAcwB1AGwAdABzACAAdwBpAHQAaABvAHUAdAAgACcARABJAFMAVABJAE4AQwBUACcAIABpAG4AIABqAGEAYwBrAHIAYQBiAGIAaQB0AA== acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_23AEE71D54A5D343BD05B0CA6A73E833022BDB9D1726PBINAMSG01M_" MIME-Version: 1.0 X-CFilter-Loop: Reflected --_000_23AEE71D54A5D343BD05B0CA6A73E833022BDB9D1726PBINAMSG01M_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I know JCR standard don't include ' DISTINCT' in SQL 2. But do you have so= me recommend way to remove duplicates from query results, and I still can = easily implement paging function, like 1st query I want distinct record fro= m 1-20 non-duplicated, 2nd want 21-40 non-duplicated records. Thanks --_000_23AEE71D54A5D343BD05B0CA6A73E833022BDB9D1726PBINAMSG01M_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I know JCR standard don't include ' DISTINCT' in SQL 2= . But do you have some recommend way to remove duplicates from query results, and I still can easily implement paging function, like 1st query I want distinct record from 1-20 non-duplicated, 2nd want 21-40 non-duplicate= d records.

Thanks

--_000_23AEE71D54A5D343BD05B0CA6A73E833022BDB9D1726PBINAMSG01M_--