摘要：SELECT DISTINCT(EXTRACT(MONTH FROM start_date_time)) FROM examinationDISTINCT:去除重复的项 select distinct name, id from table ：//去除name和id都相同的项EXTRACT：取出时间对应的项、 mysql:参考http://www.java2s.com/Tutorial/MySQL... 阅读全文