eClerx Interview Question
How to get records from table based on Year and Month?
Interview Answer
Anonymous
Jul 13, 2018
SELECT * FROM tablename WHERE MONTH(tablename .happened_at) = 1 AND YEAR(tablename .happened_at) = 2009 It will get records of January,2009
1