Skip to content

Instantly share code, notes, and snippets.

@machinelearningplus

machinelearningplus/sql_window_4.sql

Created September 11, 2023 03:26
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/895c04e49e832bc582aa23ef4ee26644 to your computer and use it in GitHub Desktop.
Save machinelearningplus/895c04e49e832bc582aa23ef4ee26644 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql_window_4.sql
CREATE TABLE employees (
emp_id INT PRIMARY KEY,
join_date DATE,
salary INT
);
INSERT INTO employees (emp_id, join_date, salary)
VALUES
(1, '2022-01-01', 1000),
(2, '2022-01-10', 1100),
(3, '2022-01-15', 1200);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment