MySQL Forums
Forum List  »  Newbie

Re: Nested SELECT
Posted by: it99ama
Date: April 13, 2005 10:36AM

I did like this:

SELECT DISTINCT YEAR( content.date ) AS Expr1
FROM content
WHERE YEAR( content.date ) IS NOT null
AND YEAR( content.date) < YEAR(CURDATE())


I got the same result ;-)

/Anders

Options: ReplyQuote


Subject
Written By
Posted
April 12, 2005 01:41PM
April 12, 2005 01:48PM
April 12, 2005 01:56PM
Re: Nested SELECT
April 13, 2005 10:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.