Talk About Network

Google


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 > Re: GROUP BY & ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 6 Topic 3668 of 3800
 Post > Topic >>

Re: GROUP BY & column not in select list

by Lew <lew@[EMAIL PROTECTED] > Mar 3, 2008 at 10:01 AM

Lew wrote:
>  SELECT name, MAX(userid) AS userid, MAX(age)
>   FROM users GROUP BY name
>    ORDER BY name;

Crap.  This won't work.

-- 
Lew




 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 Fri Jul 25 17:35:30 CDT 2008.