Search
 
SCRIPT & CODE EXAMPLE
 

SQL

get data every 30 days in sql

SELECT * FROM product 
WHERE pdate BETWEEN datetime('now', '-30 days') AND datetime('now', 'localtime')
Comment

PREVIOUS NEXT
Code Example
Sql :: how to find the number of rows updated in oracle pl/sql 
Sql :: difference between primary key and unique key 
Sql :: drop all tables in azure sql database 
Sql :: date format mysql 
Sql :: how to inner join 4 tables in sql 
Sql :: sql date format dd-mm-yyyy 
Sql :: mysql update two tables at once 
Sql :: SQL Multiple Cases 
Sql :: json query 
Sql :: oracle drop sequence if exists 
Sql :: sql update insert and delete 
Sql :: sql count unique values in one column 
Sql :: get last 50 rows sql 
Sql :: activate log mariadb 
Sql :: como saber si tengo mysql instalado 
Sql :: oracle table free space 
Sql :: how to get date in sql 
Sql :: mysql query with sql to get the next row 
Sql :: oracle index size calculation 
Sql :: sql server select last row of each item in group by column 
Sql :: Index a database column sql 
Sql :: get the location of where postgres database is stored 
Sql :: oracle dependency 
Sql :: list table columns mysql 
Sql :: inner join 
Sql :: sql datitime to date 
Sql :: postgresql default value 
Sql :: postgresql if else endif 
Sql :: print hello world in sql 
Sql :: union vs intersect sql 
ADD CONTENT
Topic
Content
Source link
Name
4+3 =