MySQL:    https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
CREATE TABLE members (
    firstname VARCHAR(25) NOT NULL,
    lastname VARCHAR(25) NOT NULL,
    username VARCHAR(16) NOT NULL,
    email VARCHAR(35),
    joined DATE NOT NULL
)
PARTITION BY KEY(joined)
PARTITIONS 6
Go

GreenPlum:  http://media.gpadmin.me/wp-content/uploads/2012/11/GPDBAGuide.pdf  (Page 52 of document)
CREATE TABLE sales (id int, date date, amt decimal(10,2))
DISTRIBUTED BY (id)
PARTITION BY RANGE (date)
( START (date '2008-01-01') INCLUSIVE
END (date '2009-01-01') EXCLUSIVE
EVERY (INTERVAL '1 day') )
go

Oracle12:   http://www.oracle-dba-online.com/sql/oracle_table_partition.htm
CREATE TABLE "products1"
     ("partno" NUMBER,
      "description" VARCHAR2 (60))
   PARTITION BY HASH ("partno")
   PARTITIONS 4  
Go

DB2LUW: http://www-01.ibm.com/support/knowledgecenter/api/content/nl/en-us/SSEPGG_10.5.0/com.ibm.db2.luw.admin.partition.doc/doc/c0021557.html
CREATE TABLE customer (l_shipdate DATE, l_name CHAR(30)) 
PARTITION BY RANGE(l_shipdate) (STARTING FROM ('01/01/2006') 
ENDING AT ('12/31/2006') EVERY (3 MONTHS))
GO

Saphana: https://scn.sap.com/thread/3171886
CREATE COLUMN TABLE mytab (a INT, b INT, c INT, PRIMARY KEY (a,b))
PARTITION BY HASH (a, b) PARTITIONS 3
go

PostgreSQL: http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html
CREATE TABLE measurement (
    city_id         int not null,
    logdate         date not null,
    peaktemp        int,
    unitsales       int
)
go

CREATE TABLE measurement_y2006m02 (
    CHECK ( logdate >= DATE '2006-02-01' AND logdate < DATE '2006-03-01' )
) INHERITS (measurement)
go
CREATE TABLE measurement_y2006m03 (
    CHECK ( logdate >= DATE '2006-03-01' AND logdate < DATE '2006-04-01' )
) INHERITS (measurement)
go

CREATE INDEX measurement_y2006m02_logdate ON measurement_y2006m02 (logdate);
go
CREATE INDEX measurement_y2006m03_logdate ON measurement_y2006m03 (logdate)
Go