Answers for "sql query to get data for last 2 years in mysql"

mysql select last 10 rows

SELECT * FROM tableName ORDER BY col1 DESC LIMIT 10;

Posted by: Guest on August-13-2021

mysql get last 2 month data

SELECT * FROM d_jobs WHERE  `job_date` >= last_day(now()) + interval 1 day - interval 3 month;

Posted by: Guest on July-09-2020

Code answers related to "sql query to get data for last 2 years in mysql"