Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql get last 2 month data

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

PREVIOUS NEXT
Code Example
Sql :: remove foreign key constraints in postgres 
Sql :: python uuid sqlalchemy 
Sql :: mysql delete database 
Sql :: android studio SQLiteDatabase delete all data in database 
Sql :: sql value exists in column 
Sql :: sql query to select even numbers 
Sql :: add time to date sql 
Sql :: how to set a column as unique in sql server 
Sql :: oracle index size calculation 
Sql :: query by column for substring sql 
Sql :: how to join tables in sql 
Sql :: SQL: get date difference in minutes 
Sql :: role "postgres" does not exist 
Sql :: delete data from database sqlite android 
Sql :: q operator in oracle 
Sql :: pgsql is not permitted to log in 
Sql :: view table mysql 
Sql :: mysql not defined 
Sql :: sql server split string last 
Sql :: create table like another table 
Sql :: postgresql default value 
Sql :: sql select row with max date 
Sql :: select users with same username 
Sql :: query to delete a database in mysql 
Sql :: ORA-01090: shutdown in progress - connection is not permitted 
Sql :: sql left join 
Sql :: t sql dynamic top n query 
Sql :: oracle avg 
Sql :: select value from previous row in postgresql 
Sql :: create a PostgreSQL user django on mac 
ADD CONTENT
Topic
Content
Source link
Name
1+3 =