hi all,
i have a table looks like this:
ID sDate
1 1997-03-21
2 1997-04-30
3 1997-05-30
4 1998-01-29
5 1998-02-24
6 1998-03-21
7 1999-05-10
8 1999-07-12
9 1999-10-20
10 2000-01-01
11 2000-02-15
12 2000-03-20
13 2000-05-18
how do i construct my select statement so that i only get distinct year?
so the above data will return something like this:
sDate
2000
1999
1998
1997
thanks,
t. hiep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
