On Fri, 18 Jan 2008, Sebastian Mendel wrote:
Hiep Nguyen schrieb:
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
did your tried:
SELECT DISTINCT YEAR(`sDate`);
--
Sebastian
thanks, that's perfect.
t. hiep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]