Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
u4_databaser [2012-03-19 08:19]
Joakim Forsgren 		u4_databaser [2012-03-19 09:00]
Joakim Forsgren
Line 83: Line 83:
 SELECT YEAR(DateTime) as Year ,COUNT(DISTINCT DAYOFYEAR(DateTime)) AS  SELECT YEAR(DateTime) as Year ,COUNT(DISTINCT DAYOFYEAR(DateTime)) AS 
 Days FROM Dates GROUP BY YEAR(Datetime) HAVING Days=366; Days FROM Dates GROUP BY YEAR(Datetime) HAVING Days=366;
 +alt.
 +SELECT * FROM (SELECT YEAR(DateTime) as Year ,COUNT(DISTINCT DAYOFYEAR(DateTime)) AS 
 +Days FROM Dates GROUP BY YEAR(Datetime)) as foo WHERE Days=366
 +
 */ */
 </php> </php>
-