only last date statement in mySQL

[bogtom]

what is wrong in this statement ? I need to get only the last modified subject from a table.



SELECT subject, date_modified FROM notes d INNER JOIN

(SELECT MAX(notes.date_modified) AS maxdate FROM notes AS mx)

ON mx.maxdate = d.date_modified



10x

 

[DotNetGnat]

try this:

SELECT subject, date_modified FROM notes d INNER JOIN

(SELECT MAX(notes.date_modified) AS maxdate FROM notes AS mx) AS P

ON P.maxdate = d.date_modified

-DNG

 

[DotNetGnat]

oops...try this

SELECT subject, date_modified FROM notes d INNER JOIN

(SELECT MAX(notes.date_modified) AS maxdate FROM notes) AS mx

ON mx.maxdate = d.date_modified

-DNg

 

[bogtom]

10x, but it didn't works:

-------------------

SQL query:

SELECT date_modified
FROM notes d
INNER JOIN (


SELECT MAX( notes.date_modified ) AS maxdate
FROM notes
) AS mx ON mx.maxdate = d.date_modified

-----------------------------

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT MAX(notes.date_modified) AS maxdate FROM notes) AS mx

 

[DotNetGnat]

check this link:

http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html

and change your query accordingly...

-DNG

 

[r937]

i wouldn't bother with anything more complex than this --

select subject
     , date_modified 
  from notes 
order 
    by date_modified desc
limit 1

r937.com | rudy.ca