Skip to content

Instantly share code, notes, and snippets.

@machinelearningplus

machinelearningplus/sql_window_2.sql

Created September 10, 2023 11:08
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/c0abd01421a13564d9274ce7dff0005a to your computer and use it in GitHub Desktop.
Save machinelearningplus/c0abd01421a13564d9274ce7dff0005a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql_window_2.sql
CREATE TABLE employees (
emp_id INT PRIMARY KEY,
dept_id INT,
salary INT
);
INSERT INTO employees (emp_id, dept_id, salary)
VALUES
(1, 10, 50000),
(2, 10, 55000),
(3, 20, 60000),
(4, 20, 65000);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment