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]
