From: Rick James
Date: September 18 2012 6:05pm
Subject: RE: getting certain rows from a group by
List-Archive: http://lists.mysql.com/mysql/228185
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148B889D32@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

Rm9yIHNpbmdsZSBxdWVyeS4uLg0KDQpQbGFuIEE6DQpSZXBlYXQgdGhlIFNFTEVDVCBhcyBvbmNl
IGZvciBlYWNoIChNSU4sIEFWRywgZXRjKSBhcyBhIHN1YnF1ZXJ5IGluDQogICBXSEVSRSBib3R0
b20gPSAoIFNFTEVDVCBNSU4oYm90dG9tKSAuLi4gKQ0KDQpQbGFuIEI6DQogICBGUk9NICggU0VM
RUNUIEBtaW4gPSBNSU4oYm90dG9tKSwNCiAgICAgICAgICAgICAgICAgQG1heCA9IE1BWChib3R0
b20pLCAuLi4gKQ0KICAgSk9JTiBkYXRhX2NzdCBtbiAgT04gYm90dG9tID0gQG1pbg0KICAgSk9J
TiBkYXRhX2NzdCBteCAgT04gYm90dG9tID0gQG1heCANCg0KUGxhbiBDOg0KR2V0IHJpZCBvZiAz
cmQgcGFydHkgcGFja2FnZXMgdGhhdCBldmVudHVhbGx5IGdldCBpbiB5b3VyIHdheSBpbnN0ZWFk
IG9mICdoZWxwaW5nJy4NCg0KDQo+IC0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQo+IEZyb206
IExhcnJ5IE1hcnRlbGwgW21haWx0bzpsYXJyeS5tYXJ0ZWxsQGdtYWlsLmNvbV0NCj4gU2VudDog
VHVlc2RheSwgU2VwdGVtYmVyIDE4LCAyMDEyIDQ6NTcgQU0NCj4gVG86IHBldGVyLmJyYXdsZXlA
ZWFydGhsaW5rLm5ldA0KPiBDYzogbXlzcWxAbGlzdHMubXlzcWwuY29tDQo+IFN1YmplY3Q6IFJl
OiBnZXR0aW5nIGNlcnRhaW4gcm93cyBmcm9tIGEgZ3JvdXAgYnkNCj4gDQo+IE9uIFR1ZSwgU2Vw
IDE4LCAyMDEyIGF0IDc6NTIgQU0sIFBldGVyIEJyYXdsZXkNCj4gPHBldGVyLmJyYXdsZXlAZWFy
dGhsaW5rLm5ldD4gd3JvdGU6DQo+ID4gT24gMjAxMi0wOS0xOCA1OjUzIEFNLCBMYXJyeSBNYXJ0
ZWxsIHdyb3RlOg0KPiA+Pg0KPiA+PiBJIGhhdmUgdGhpcyBxdWVyeToNCj4gPj4NCj4gPj4gU0VM
RUNUIGRhdGFfdGFyZ2V0Lm5hbWUgYXMgVGFyZ2V0LA0KPiA+PiAgICAgICAgIHExLmVwIGFzIEVQ
LA0KPiA+PiAgICAgICAgIENPVU5UKCopIGFzIFdhZmVycywNCj4gPj4gICAgICAgICBMb3RzLA0K
PiA+PiAgICAgICAgIFNVTShudW1vbmVwKS8oQ09VTlQoKikrU1VNKENBU0UgV0hFTiByZXJ1bnMg
PiAwIFRIRU4gcmVydW5zDQo+ID4+IEVMU0UgMCBFTkQpKSBhcyAnU2l0ZXMvV2FmZXInLA0KPiA+
PiAgICAgICAgIE1BWChMYXN0UnVuKSBhcyAiTGFzdCBSdW4iLA0KPiA+PiAgICAgICAgIFNVTShD
QVNFIFdIRU4gcmVydW5zID4gMCBUSEVOIHJlcnVucyBFTFNFIDAgRU5EKSBhcyBSZXJ1biwNCj4g
Pj4gICAgICAgICBDT1VOVCgqKStTVU0oQ0FTRSBXSEVOIHJlcnVucyA+IDAgVEhFTiByZXJ1bnMg
RUxTRSAwIEVORCkgYXMNCj4gUnVucywNCj4gPj4gICAgICAgICBhdmdib3R0b20gYXMgIkF2ZyBC
b3R0b20iLA0KPiA+PiAgICAgICAgIDMqc3RkYm90dG9tIGFzICIzIFNpZyIsDQo+ID4+ICAgICAg
ICAgbWF4Ym90dG9tIGFzIE1heCwNCj4gPj4gICAgICAgICBtaW5ib3R0b20gYXMgTWluLA0KPiA+
PiAgICAgICAgIFNVTShudW1vbmVwKSBhcyBDb3VudCwNCj4gPj4gICAgICAgICBTVU0obnVtb25l
cCkgLSBTVU0obnVtYm90dG9tcykgYXMgTkFzLA0KPiA+PiAgICAgICAgIDEwMC0oKFNVTShudW1v
bmVwKSAtIFNVTShudW1ib3R0b21zKSkvU1VNKG51bW9uZXApKjEwMCkgYXMNCj4gIiUNCj4gPj4g
U3VjY2VzcyIsDQo+ID4+ICAgICAgICAgMypzdGRib3R0b20vYXZnYm90dG9tIGFzICIzU2lnL0F2
ZyIsDQo+ID4+ICAgICAgICAgQVZHKGF2Z2JvdHRvbSkgYXMgJ1dhZmVyIEF2ZycsDQo+ID4+ICAg
ICAgICAgQVZHKFdhZmVyM1NpZ21hKSBhcyAnV2FmZXIgMyBTaWdtYScsDQo+ID4+ICAgICAgICAg
QVZHKFJhbmdlcykgYXMgJ0F2ZyBSYW5nZScsDQo+ID4+ICAgICAgICAgMypTVEQoUmFuZ2VzKSBh
cyAnM1NpZyBvZiBSYW5nZXMnLA0KPiA+PiAgICAgICAgIE1BWChSYW5nZXMpIGFzICdNYXggUmFu
Z2UnLA0KPiA+PiAgICAgICAgIE1JTihSYW5nZXMpIGFzICdNaW4gUmFuZ2UnLA0KPiA+PiAgICAg
ICAgIChTVU0obnVtb25lcCkgLSBTVU0obnVtYm90dG9tcykpL0NPVU5UKCopIGFzICdOQXMvV2Fm
ZXInDQo+ID4+IEZST00gKFNFTEVDVCB0YXJnZXRfbmFtZV9pZCwNCj4gPj4gICAgICAgICAgICAg
ICBlcCwNCj4gPj4gICAgICAgICAgICAgICB3YWZlcl9pZCwNCj4gPj4gICAgICAgICAgICAgICBD
T1VOVChib3R0b20pIGFzIG51bWJvdHRvbXMsDQo+ID4+ICAgICAgICAgICAgICAgQVZHKGJvdHRv
bSkgYXMgYXZnYm90dG9tLA0KPiA+PiAgICAgICAgICAgICAgIFNURChib3R0b20pIGFzIHN0ZGJv
dHRvbSwNCj4gPj4gICAgICAgICAgICAgICBNQVgoYm90dG9tKSBhcyBtYXhib3R0b20sDQo+ID4+
ICAgICAgICAgICAgICAgTUlOKGJvdHRvbSkgYXMgbWluYm90dG9tLA0KPiA+PiAgICAgICAgICAg
ICAgIE1BWChkYXRlX3RpbWUpIGFzICJMYXN0UnVuIiwNCj4gPj4gICAgICAgICAgICAgICBDT1VO
VCgqKSBhcyBudW1vbmVwLA0KPiA+PiAgICAgICAgICAgICAgIENPVU5UKERJU1RJTkNUIHRhcmdl
dF9uYW1lX2lkLCBlcCwgbG90X2lkLA0KPiA+PiBkYXRhX2ZpbGVfaWQpLTEgYXMgcmVydW5zLA0K
PiA+PiAgICAgICAgICAgICAgIENPVU5UKERJU1RJTkNUKGxvdF9pZCkpIGFzIExvdHMsDQo+ID4+
ICAgICAgICAgICAgICAgMypTVEQoYm90dG9tKSBhcyBXYWZlcjNTaWdtYSwNCj4gPj4gICAgICAg
ICAgICAgICBNQVgoYm90dG9tKSAtIE1JTihib3R0b20pIGFzIFJhbmdlcw0KPiA+PiAgICAgICAg
RlJPTSBkYXRhX2NzdA0KPiA+PiAgICAgICAgV0hFUkUgdGFyZ2V0X25hbWVfaWQgSU4gKDc3NSwg
Nzc2LCA3NzcsIDc3OCwgNzc5LCA3ODAsIDQ1LA0KPiA0NCwNCj4gPj4gMTE2LCAxMTcsIDExOCwg
MTE5LCAxMjAsIDEyMSkNCj4gPj4gICAgICAgIEFORCBkYXRhX2NzdC5kYXRlX3RpbWUgQkVUV0VF
TiAnMjAxMC0wMy0wNCAwMDowMDowMCcgQU5EDQo+ID4+ICcyMDEwLTAzLTA0IDIzOjU5OjU5Jw0K
PiA+PiAgICAgICAgR1JPVVAgQlkgdGFyZ2V0X25hbWVfaWQsIGVwLCB3YWZlcl9pZA0KPiA+PiAg
ICAgICAgSEFWSU5HIGNvdW50KCopIDwgOTk5KSBxMSwNCj4gPj4gICAgICAgZGF0YV90YXJnZXQN
Cj4gPj4gV0hFUkUgZGF0YV90YXJnZXQuaWQgPSB0YXJnZXRfbmFtZV9pZCBHUk9VUCBCWSBxMS50
YXJnZXRfbmFtZV9pZCwNCj4gPj4gcTEuZXA7DQo+ID4+DQo+ID4+DQo+ID4+IFRoaXMgd29ya3Mg
ZmluZS4gQnV0IG5vdyBJIG5lZWQgdG8gZ2V0IGEgY2VydGFpbiBjb2x1bW4NCj4gPj4gKGltYWdl
X21lYXN1cmVyX2lkKSB3aXRoIGVhY2ggcm93IHJldHVybmVkIHRoYXQgY29ycmVzcG9uZHMgdG8g
dGhlDQo+ID4+IHJvdyBmcm9tIHRoZSBncm91cCB0aGF0IGhhcyBib3R0b20gPSBNaW4oYm90dG9t
KSwgYm90dG9tID0NCj4gPj4gTWF4KGJvdHRvbSksIGJvdHRvbSBjbG9zZXN0IHRvIEF2Zyhib3R0
b20pLCBhbmQgYm90dG9tIGZyb20gdGhlIHJvdw0KPiA+PiB3aGVyZSBkYXRlX3RpbWUgPSBNYXgo
ZGF0ZV90aW1lKS4NCj4gPj4NCj4gPj4gSXMgdGhpcyBldmVuIHBvc3NpYmxlIGZyb20gb25lIHF1
ZXJ5Pw0KPiA+DQo+ID4NCj4gPiBNaWdodCBiZSwgYnV0IHdoYXQncyB0aGUgaW1wb3J0YW5jZSBv
ZiBkb2luZyBpdCBhcyBvbmUgcXVlcnk/DQo+IA0KPiBCZWNhdXNlIGl0J3MgcGFydCBvZiBhIGRq
YW5nbyBiYXNlZCB3ZWIgYXBwLCBhbmQgdGhlIGNsYXNzIHRoYXQgdGhpcyBpcw0KPiBwYXJ0IG9m
IG9ubHkgc3VwcG9ydHMgaGF2aW5nIGEgc2luZ2xlIHF1ZXJ5LiBUbyB1c2UgbXVsdGlwbGUgcXVl
cmllcw0KPiB3aWxsIHJlcXVpcmUgYSBmYWlybHkgbWFqb3IgcmV3cml0ZSBvZiB0aGUgc2VydmVy
IHNpZGUgb2YgdGhhdCBhcHAuDQo+IA0KPiA+IEknZCBzdGFydCBieQ0KPiA+IHNhdmluZyB0aGlz
IHJlc3VsdCB0byBhIHRlbXAgdGFibGUgYW5kIGRldmVsb3BpbmcgdGhlIG5ldyBxdWVyeS4gV2hl
bg0KPiA+IHRoYXQncyBydW5uaW5nLCBzZWUgaWYgeW91IGNhbiB0byBvcHRpbWlzZSBhIHF1ZXJ5
IGJ1aWx0IGJ5IHJlcGxhY2luZw0KPiA+IHRoZSByZWZlcmVuY2UgdG8gdGhlIHRlbXAgdGFibGUg
d2l0aCB0aGUgb3JpZ2luYWwgcXVlcnkuDQo+IA0KPiBUaGFua3MsIEknbGwgbG9vayBpbnRvIHRo
aXMuDQo+IA0KPiAtLQ0KPiBNeVNRTCBHZW5lcmFsIE1haWxpbmcgTGlzdA0KPiBGb3IgbGlzdCBh
cmNoaXZlczogaHR0cDovL2xpc3RzLm15c3FsLmNvbS9teXNxbA0KPiBUbyB1bnN1YnNjcmliZTog
ICAgaHR0cDovL2xpc3RzLm15c3FsLmNvbS9teXNxbA0KDQo=