List:General Discussion« Previous MessageNext Message »
From:Leonardo Rodrigues Magalhães Date:September 5 2003 2:59am
Subject:Re: MAX in a SubSelect
View as plain text  
        MySQL 4.0 (the current stable brench) does not support subqueries.
This feature is present in the beta brench of MySQL, v4.1.

http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#ANSI_diff_Subqueries

    Sincerily,
    Leonardo Rodrigues

----- Original Message ----- 
From: "Oscar (TOMCAT)" <oscar.tomcat@stripped>
To: <mysql@stripped>
Sent: Thursday, September 04, 2003 11:45 PM
Subject: MAX in a SubSelect


Hi,

I'm using MySQL 4.0.1 for Linux/Windows... I need to perform a query like
this:

SELECT AVALIACAO, COUNT(AVALIACAO)
FROM AUDITORIAS
WHERE IDVERSAO = (SELECT MAX(IDVERSAO) FROM VERSOES WHERE DATA =
'2003-08-23')
GROUP BY AVALIACAO

And its doesn't work in this version...

There is other way to do that ???

Thread
MAX in a SubSelectTOMCAT)5 Sep
  • Re: MAX in a SubSelectLeonardo Rodrigues Magalhães5 Sep