From: Hiep Nguyen (hiepee.ucr.edu)
Date: Fri Jan 18 2008 - 07:21:52 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]