Sql

-- MySQL
DATE_SUB(NOW(), INTERVAL '1 YEAR')
-- PostgreSQL
(NOW() - INTERVAL '1 YEAR')

PREVIOUS	NEXT

Code Example
Sql :: oracle revoke
Sql :: mysql backup table
Sql :: find the median in sql
Sql :: how to generate a unique random number in mysql
Sql :: sql table
Sql :: plpgsql create function
Sql :: mysql change default collation
Sql :: laravel general error 2006 mysql server has gone away
Sql :: varchar vs nvarchar sql
Sql :: install mysql on ubuntu
Sql :: oracle apex view logs
Sql :: sql line numbers
Sql :: insensitive case match sqlalchemy
Sql :: how to connect postgresql database with java
Sql :: how to find third highest salary in sql
Sql :: update one column from another column in same table
Sql :: oracle drop job if exists
Sql :: SQL UNION ALL Operator
Sql :: postgres duplicate key value violates unique constraint already exists
Sql :: mysql server not starting in xampp in mac
Sql :: date in oracle
Sql :: remove auto increment mysql
Sql :: mysql count multiple columns in one query
Sql :: postgresql grant owner to user
Sql :: calculate percentage in sql
Sql :: mysql change value
Sql :: insert into values select
Sql :: replace divide by zero error with 0 in sql
Sql :: date sql
Sql :: postgres recursive function