My Sql

• MySql Functions
  DATE_SUB() Getting the recent one month or year records from MySQL table Syntax of DATE_SUB() DATE_SUB(date, INTERVAL, expression, UNIT) ...
• group by date in where clause
  SELECT ...