We Provide Latest Interview Questions for all type's companies,which repeatedly asked by interviews,Like
Java,Php,SQL,.net,Jquery,hibernate,Javascript,J2EE,J2ME,
networking.
Thursday, December 6, 2012
How to select past 7 days records from MySQL
SELECT * FROM tablename.user_stats where upadtedDate between '2012-11-18' and '2012-12-6' and loginId=2
SELECT * FROM tablename.user_stats where upadtedDate BETWEEN DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND CURDATE()
No comments:
Post a Comment