Skip to content

Instantly share code, notes, and snippets.

@machinelearningplus

machinelearningplus/sql_window_3.sql

Created September 10, 2023 11:40
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/22cc123427fef569739a8517afce43c0 to your computer and use it in GitHub Desktop.
Save machinelearningplus/22cc123427fef569739a8517afce43c0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql_window_3.sql
CREATE TABLE stockprices (
date DATE,
price DECIMAL(10, 2)
);
INSERT INTO stockprices
VALUES
('2022-01-01', 100.50),
('2022-01-02', 101.75),
('2022-01-03', 102.00),
('2022-01-04', 103.00),
('2022-01-05', 103.50),
('2022-01-06', 107.00);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment