Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
u4_databaser [2012-03-19 08:19] Joakim Forsgren |
u4_databaser [2012-09-26 17:26] Joakim Forsgren |
||
|---|---|---|---|
| Line 33: | Line 33: | ||
| </ | </ | ||
| - | Nu skall nu använda min databas **jf**. Om du inte kommer ihåg hur man loggade in kolla: [[u1_databaser]]\\ | + | Nu skall du använda min databas **jf**. Om du inte kommer ihåg hur man loggade in kolla: [[u1_databaser]]\\ |
| Tabellen heter Dates. | Tabellen heter Dates. | ||
| Line 83: | Line 83: | ||
| SELECT YEAR(DateTime) as Year , | SELECT YEAR(DateTime) as Year , | ||
| 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 , | ||
| + | Days FROM Dates GROUP BY YEAR(Datetime)) as foo WHERE Days=366 | ||
| + | |||
| */ | */ | ||
| </ | </ | ||
| - | |||