Skip to content

Instantly share code, notes, and snippets.

@machinelearningplus

machinelearningplus/sql_window_1.sql

Last active September 10, 2023 10:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save machinelearningplus/752971b25fcc4f15d53765c53d3ff3a1 to your computer and use it in GitHub Desktop.
Save machinelearningplus/752971b25fcc4f15d53765c53d3ff3a1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql_window_1.sql
CREATE TABLE sales (
sale_id INT PRIMARY KEY,
sale_date DATE,
amount INT
);
INSERT INTO sales (sale_id, sale_date, amount)
VALUES
(1, '2022-01-01', 100),
(2, '2022-01-05', 150),
(3, '2022-02-15', 200),
(4, '2022-02-20', 250),
(5, '2022-03-10', 300);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment