+--------+------------+-------------+ | itemID | item | date | +--------+------------+-------------+ | 1 | event1 | 2012-09-05 | | 2 | event2 | 2010-03-02 | | 3 | event3 | 2012-11-01 | | 4 | event4 | 2011-04-11 | | 5 | event5 | 2011-05-08 | | 6 | event6 | 2009-06-02 | | 7 | event7 | 2011-07-04 | | 8 | event8 | 2012-09-06 | | 8 | event9 | 2011-08-11 | +--------+------------+-------+-----+
SELECT YEAR(date) FROM Event GROUP BY YEAR(date) HAVING COUNT(date) >= 2 ORDER BY date DESC
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)