Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql delete records older than 1 day

...
WHERE date < DATEADD(day, -30, GETDATE())
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql select from outside 
Sql :: oracle db create new schema 
Sql :: how to insert string variable into sqlite database 
Sql :: mysql extract month 
Sql :: how to get ddl for materialized view 
Sql :: list index mysql cli 
Sql :: oracle apex list connected users 
Sql :: c# get sql min date 
Sql :: search query in mysql 
Sql :: mysql add 2 hours 
Sql :: mysql bigint max value 
Sql :: postgresql add alter permissions to role 
Sql :: the package java.sql is not accessible 
Sql :: show tables in schema oracle 
Sql :: select statement to print longest name 
Sql :: postgres list tables and row counts 
Sql :: import .sql into postgres db command 
Sql :: select first rows postgresql 
Sql :: mysql change primary key 
Sql :: MSSQL SYNTAX PROCEDURE FUNCTION TRIGGER 
Sql :: how to add foreign key constraint in sql 
Sql :: upper and lower in oracle sql 
Sql :: python escape string for sql 
Sql :: mysql create table like 
Sql :: sql last updated 
Sql :: oracle db get table sizes 
Sql :: sql syntax create timestamp column 
Sql :: xml path sql server 
Sql :: oracle auto_increment 
Sql :: coalesce postgresql 
ADD CONTENT
Topic
Content
Source link
Name
2+5 =