Hi, AFAIK, date is *not* a reserved keyword, not need to backtick it :)
Regards, Jocelyn Fournier www.presence-pc.com ----- Original Message ----- From: "Michael Stassen" <[EMAIL PROTECTED]> To: "fgmmoribe" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, July 27, 2004 7:11 AM Subject: Re: select in Mysql 4.0 > > fgmmoribe wrote: > > I have a table like this > > > > +-------------+-------------------+------+-----+---------+----------------+ > > | Field | Type | Null | Key | Default | Extra | > > +-------------+-------------------+------+-----+---------+----------------+ > > | id | int(3) | | PRI | NULL | auto_increment | > > | idTable | int(3) unsigned | | | 0 | | > > | title | varchar(150) | YES | | NULL | | > > | description | varchar(150) | YES | | NULL | | > > | date | datetime | YES | | NULL | | > > +-------------+-------------------+------+-----+---------+----------------+ > > > > Is there anyway to make select command like this in Mysql 4.0: > > select * from #temp where cod in (select max(cod) from #temp > > group by idtable) order by data desc > > > > could someone help me? > > > > thanks > > > > Fernando > > Subqueries require mysql 4.1. > > date is a reserved word, so not the best choice for a column name. You'll > always have to quote it with backticks to use it. > > Your query doesn't seem to match your table. > > That said, I think you want > <http://dev.mysql.com/doc/mysql/en/example-Maximum-column-group-row.html>. > > Michael > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]