Skip to content

Instantly share code, notes, and snippets.

@alogic0

alogic0/1.sql

Created July 24, 2018 17:30
Show Gist options
  • Save alogic0/e2c6fa552eea8624ad9b62bcbfc3e82b to your computer and use it in GitHub Desktop.
Save alogic0/e2c6fa552eea8624ad9b62bcbfc3e82b to your computer and use it in GitHub Desktop.
Download ZIP
SQL lessons
Raw
1.sql
-- https://www.w3schools.com/sql/trysql.asp
CREATE TABLE Countries(
ID int IDENTITY(1,1) PRIMARY KEY,
Country varchar(255),
Continent varchar(255)
);
INSERT INTO Countries (Country)
SELECT DISTINCT Country FROM Customers;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment