Talk About Network



Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Java Databases > GROUP BY & colu...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 3668 of 3747
Post > Topic >>

GROUP BY & column not in select list

by anssiman@[EMAIL PROTECTED] Mar 3, 2008 at 06:25 AM

Hi,

is there any way to cheat group by -statement or make the query in
other way? I mean that query:

SELECT userid, name, MAX(age) FROM users GROUP BY name;

produces list of the oldest users grouped by the name, but the
userid is also available (this way it is not valid at all).

Table contains rows:
....
12 | Jack | 18
13 | Jim   | 22
14 | Jack | 56
....

and the query above should return:
13 | Jim   | 22
14 | Jack | 56

Keen to know if there is solution!

Regards,

anssi




 6 Posts in Topic:
GROUP BY & column not in select list
anssiman@[EMAIL PROTECTED  2008-03-03 06:25:21 
Re: GROUP BY & column not in select list
Lew <lew@[EMAIL PROTEC  2008-03-03 09:59:32 
Re: GROUP BY & column not in select list
Lew <lew@[EMAIL PROTEC  2008-03-03 10:01:58 
Re: GROUP BY & column not in select list
Lew <lew@[EMAIL PROTEC  2008-03-03 10:31:15 
Re: GROUP BY & column not in select list
=?ISO-8859-1?Q?Arne_Vajh=  2008-03-03 22:29:28 
Re: GROUP BY & column not in select list
anssiman@[EMAIL PROTECTED  2008-03-03 23:52:28 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed May 14 23:56:50 CDT 2008.