Skip to content

Instantly share code, notes, and snippets.

@sharikovvladislav

sharikovvladislav/SQL Sample

Created June 16, 2014 18:39
Show Gist options
  • Save sharikovvladislav/75d4d326829de592eb72 to your computer and use it in GitHub Desktop.
Save sharikovvladislav/75d4d326829de592eb72 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SQL Sample
SELECT
c.id,
s.name as supplierName,
s.id as supplierId,
c.conclusionDate,
ADDDATE(c.conclusionDate INTERVAL c.period YEAR) as cancelDate,
c.period
FROM
Contracts as c
INNER JOIN
Suppliers as s
ON
s.id = c.supplier_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment