Pergunta de entrevista da empresa eClerx

How to get records from table based on Year and Month?

Resposta da entrevista

Sigiloso

13 de jul. de 2018

SELECT * FROM tablename WHERE MONTH(tablename .happened_at) = 1 AND YEAR(tablename .happened_at) = 2009 It will get records of January,2009

1