RE: Why is this an SQL syntax error?

Grouping by rowid would be pretty useless anyway, it should always be unique Will >===== Original Message From "Colleen M. Morrow" > >It would appear that you can't group by rowid. Could this be because >rowid's do not exist by default in fragmented tables? Anybody? I couldn't >find it documented anywhere. > > > > > >strangiato@my-deja.com on 05/02/2000 01:39:11 PM >Extension: > >To: informix-list@iiug.org >cc: (bcc: Colleen M. Morrow/JonesDay) >Subject: Re: Why is this an SQL syntax error? > > > > >It's a column name. I suspect there is a problem with the rowid?? > >In article <390F01AD.30A7E5DD@bellsouth.net>, > "Carlson@WHSmith" <carlson1@bellsouth.net> wrote: >> strangiato@my-deja.com wrote: >> > >> > Informix 7.x >> > >> > select p_name,rowid,max(finish_dt) from p_status where id=10 group>by >> > 1,2 >> > >> > gives rise to a syntax error >> > >> > why? >> > >> > Sent via Deja.com http://www.deja.com/ >> > Before you buy. >> >> Is p_name a column name or a program variable ?? >> >> -- >> John Carlson >> Informix DBA >> WHSmith USA >> >> #include std_disclaimer.h /* These are my opinions, not my >company's >> opinion */ >> > > >Sent via Deja.com http://www.deja.com/ >Before you buy. ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------