How to get a list of unique year from mysql database.
Есть 30 записей (`id`, `name`, `year`). 1, test, 2015 2, test, 2016 3, test, 2014 4, test, 2015 5, test, 2015 I want to get a list of
2015, 2014, 2016 
Denis Kotlyarov Denis Kotlyarov
2,014 14 silver marks 37 bronze marks
|
1 answer
distinct - to select unique elements
select distinct year from table 
Evgeny Suetin Evgeny Suetin
1,193 4 silver marks 16 bronze marks
- Yes, thanks, it works. - Denis Kotlyarov
- @ DenisKotlyarov is happy to help, then mark the message as the correct answer) - Evgeny Suetin
- 24 minutes is required :) in order to mark as correct, I did not invent it. - Denis Kotlyarov
- @ DenisKotlyarov did not know, sorry) - Evgeny Suetin
|