Return-Path: X-Original-To: apmail-cayenne-user-archive@www.apache.org Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6D4C3D244 for ; Tue, 9 Oct 2012 09:57:46 +0000 (UTC) Received: (qmail 87636 invoked by uid 500); 9 Oct 2012 09:57:46 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 87615 invoked by uid 500); 9 Oct 2012 09:57:45 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 87584 invoked by uid 99); 9 Oct 2012 09:57:45 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Oct 2012 09:57:45 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of SU0064323@techmahindra.com designates 203.143.186.40 as permitted sender) Received: from [203.143.186.40] (HELO mx21.techmahindra.com) (203.143.186.40) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Oct 2012 09:57:38 +0000 X-TM-IMSS-Message-ID: <3817aa1800043b26@MX21.techmahindra.com> Received: from sinpunhub001-x7.TechMahindra.com ([10.10.0.155]) by MX21.techmahindra.com ([192.168.60.16]) with ESMTP (TREND IMSS SMTP Service 7.1) id 3817aa1800043b26 ; Tue, 9 Oct 2012 15:25:37 +0530 Received: from SINPUNMBX001.TechMahindra.com ([10.10.0.159]) by sinpunhub001-x7.TechMahindra.com ([10.10.0.155]) with mapi; Tue, 9 Oct 2012 15:27:13 +0530 From: Sampath Uppula To: "user@cayenne.apache.org" Date: Tue, 9 Oct 2012 15:27:12 +0530 Subject: RE: How to fetch the Distinct rows based on an attribute. Thread-Topic: How to fetch the Distinct rows based on an attribute. Thread-Index: Ac2l9BARXSIFQQyzQP+sW6HdDbARNQADWCHQAAAVHZA= Message-ID: <76DA7E819C17774ABC972C63C0EC83B7159C30CF3E@SINPUNMBX001.TechMahindra.com> References: <76DA7E819C17774ABC972C63C0EC83B7159C20BA4A@SINPUNMBX001.TechMahindra.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-TM-AS-Product-Ver: IMSS-7.1.0.1394-6.8.0.1017-19254.005 X-TM-AS-Result: No--10.501-5.0-31-1 X-imss-scan-details: No--10.501-5.0-31-1 SGksDQpUaGFua3MgZm9yIHRoZSByZXNwb25zZS4NCkJ1dCB0aGlzIGlzIGp1c3QgYW4gZXhhbXBs ZS4NCkkgaGF2ZSBtYW55IHNjZW5hcmlvcywgd2hlcmUgSSBoYXZlIHRvIGZldGNoIHRoZSBkaXN0 aW5jdCByb3dzIGJhc2VkIG9uIGEgZmllbGQgKGF0dHJpYnV0ZSkuDQoNCkNhbiB5b3UgYWxzbyBw bGVhc2UgYW5zd2VyIHRoZSBpc3N1ZSMgQ0FZLTE3MzAgKGh0dHBzOi8vaXNzdWVzLmFwYWNoZS5v cmcvamlyYS9icm93c2UvQ0FZLTE3MzApPw0KDQpUaGFua3MsDQpTYW1wYXRoIFVwcHVsYQ0KDQoN Ci0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBEdXJjaGhvbHosIEpvYWNoaW0gW21h aWx0bzpKb2FjaGltLkR1cmNoaG9sekBoZW5uaWctZmFocnpldWd0ZWlsZS5kZV0gDQpTZW50OiBU dWVzZGF5LCBPY3RvYmVyIDA5LCAyMDEyIDM6MDYgUE0NClRvOiB1c2VyQGNheWVubmUuYXBhY2hl Lm9yZw0KU3ViamVjdDogUkU6IEhvdyB0byBmZXRjaCB0aGUgRGlzdGluY3Qgcm93cyBiYXNlZCBv biBhbiBhdHRyaWJ1dGUuDQoNCldoYXQgeW91IHdhbnQgdG8gZG8gZG9lcyBub3QgbWFrZSBzZW5z ZS4NCklmIHRoZXJlIGFyZSByb3dzIHRoYXQgaGF2ZSB0aGUgc2FtZSB1c2VyX2lkIGJ1dCBkaWZm ZXJlbnQgZmllbGRzIGVsc2V3aGVyZSwgd2hpY2ggb2YgdGhlc2Ugcm93cyBzaG91bGQgYmUgcmV0 dXJuZWQ/DQoNCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQoNCkZyb206IFNhbXBh dGggVXBwdWxhIFttYWlsdG86U1UwMDY0MzIzQFRlY2hNYWhpbmRyYS5jb21dIA0KU2VudDogVHVl c2RheSwgT2N0b2JlciAwOSwgMjAxMiAxMDowMCBBTQ0KVG86IHVzZXJAY2F5ZW5uZS5hcGFjaGUu b3JnDQpTdWJqZWN0OiBIb3cgdG8gZmV0Y2ggdGhlIERpc3RpbmN0IHJvd3MgYmFzZWQgb24gYW4g YXR0cmlidXRlLg0KDQoNCg0KSGksDQoNCkkgaGF2ZSAgYSB0YWJsZSB0X3VzZXJfYWxsb2NhdGlv bl9kZXRhaWxzIHdpdGggbWFueSBjb2x1bW5zLCBvbmUgb2YgdGhlIGNvbHVtbiBpcyB1c2VyX2lk Lg0KDQpJIHdhbnQgdG8gZmV0Y2ggdGhlIGRpc3RpbmN0IGRhdGEgYmFzZWQgb24gdXNlcl9pZC4N Cg0KUGxlYXNlIHN1Z2dlc3QgYSB3YXkgdG8gYWNoaWV2ZSB0aGlzLg0KDQogDQoNCkkgaGF2ZSB0 cmllZCB0aGUgYmVsb3cgbWV0aG9kIGJ1dCBpdOKAmXMgYmFzZWQgb24gYWxsIHRoZSBjb2x1bW5z IGluIHRoZSB0YWJsZS4NCg0KIA0KDQoqCXB1YmxpYyB2b2lkIHNldERpc3RpbmN0KGJvb2xlYW4g ZGlzdGluY3QpDQoJSWYgc2V0IHRvIHRydWUgKGRlZmF1bHQgaXMgZmFsc2UpLCB0ZWxscyBDYXll bm5lIHRoYXQgcXVlcnkgc2hvdWxkIGZldGNoIGRpc3RpbmN0IHJvd3MuIA0KDQogDQoNClRoYW5r cywNCg0KU2FtcGF0aCBVcHB1bGF8ZUNvbnZlcmdlbmNlLEJULTE1fFRlY2ggTWFoaW5kcmENCg0K LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoNClMxLVctNTU3MiwgV2VzdCBXaW5nLCBCbG9jay0xLCBI aW5qZXdhZGktUGhhc2UgSUlJLCBQdW5lIDQxMSAwNTcsIElORElBDQoNCiggT2ZmaWNlOiArOTEg MjAgNDIyNTAwMDAgRXh0bjogMjUwODc5IHwgQ2VsbDogKzkxIDk3MzA3NDUwNDMNCg0KRW1haWw6 IFNVMDA2NDMyM0B0ZWNobWFoaW5kcmEuY29tIDxtYWlsdG86U1UwMDY0MzIzQHRlY2htYWhpbmRy YS5jb20+IA0KDQp3d3cudGVjaG1haGluZHJhLmNvbSA8aHR0cDovL3d3dy50ZWNobWFoaW5kcmEu Y29tLz4gDQoNCiANCg0KZUNvbnZlcmdlbmNlDQoNCiANCg0KPT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PURpc2NsYWltZXI6 ICBUaGlzIG1lc3NhZ2UgYW5kIHRoZSBpbmZvcm1hdGlvbiBjb250YWluZWQgaGVyZWluIGlzIHBy b3ByaWV0YXJ5IGFuZCBjb25maWRlbnRpYWwgYW5kIHN1YmplY3QgdG8gdGhlIFRlY2ggTWFoaW5k cmEgcG9saWN5IHN0YXRlbWVudCwgeW91IG1heSByZXZpZXcgdGhlIHBvbGljeSBhdCBodHRwOi8v d3d3LnRlY2htYWhpbmRyYS5jb20vRGlzY2xhaW1lci5odG1sIGV4dGVybmFsbHkgYW5kIGh0dHA6 Ly90aW0udGVjaG1haGluZHJhLmNvbS90aW0vZGlzY2xhaW1lci5odG1sIGludGVybmFsbHkgd2l0 aGluIFRlY2ggTWFoaW5kcmEuPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PQ0KDQo9PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09RGlzY2xhaW1lcjogIFRo aXMgbWVzc2FnZSBhbmQgdGhlIGluZm9ybWF0aW9uIGNvbnRhaW5lZCBoZXJlaW4gaXMgcHJvcHJp ZXRhcnkgYW5kIGNvbmZpZGVudGlhbCBhbmQgc3ViamVjdCB0byB0aGUgVGVjaCBNYWhpbmRyYSBw b2xpY3kgc3RhdGVtZW50LCB5b3UgbWF5IHJldmlldyB0aGUgcG9saWN5IGF0IDxhIGhyZWY9Imh0 dHA6Ly93d3cudGVjaG1haGluZHJhLmNvbS9EaXNjbGFpbWVyLmh0bWwiPmh0dHA6Ly93d3cudGVj aG1haGluZHJhLmNvbS9EaXNjbGFpbWVyLmh0bWw8L2E+IGV4dGVybmFsbHkgYW5kIDxhIGhyZWY9 Imh0dHA6Ly90aW0udGVjaG1haGluZHJhLmNvbS90aW0vZGlzY2xhaW1lci5odG1sIj5odHRwOi8v dGltLnRlY2htYWhpbmRyYS5jb20vdGltL2Rpc2NsYWltZXIuaHRtbDwvYT4gaW50ZXJuYWxseSB3 aXRoaW4gVGVjaCBNYWhpbmRyYS49PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09