Reputation: 2719
in my db there are 5 fields (id, list_date, amount, total, m_from)
and contain data, for example :
1 - 1/1/2010 - 10 - 50 - 'example111'
1 - 1/1/2010 - 10 - 50 - 'example111'
1 - 1/4/2010 - 10 - 50 - 'example154
1 - 1/1/2010 - 10 - 50 - 'example111'
1 - 1/5/2010 - 10 - 50 - 'test'
I need to know how I can get dates from list_date but without repeatable dates like '1/1/2010, 1/5/2010, 1/4/2010'
Thanks in Advance.
Upvotes: 3
Views: 93
Reputation: 6763
If i'm not mistaken you can use also GROUP BY
:
SELECT list_date FROM table GROUP BY list_date
Upvotes: 0