Find Duplicates using Window Functions | EssentialSQL

If you're interested in learning SQL, then why not hop on over and get our Stored Procedures Unpacked Course Today the course today at: hthttps://www.udemy.com/course/sql-window-functions-for-business-analytics/?referralCode=84C26CC5036C1C603F56 Here is the code to create the sample data: CREATE TABLE students ( id INT PRIMARY KEY, name VARCHAR(50) NOT NULL, age INT NOT NULL ); INSERT INTO students (id, name, age) VALUES (1, 'Alice', 20), (2, 'Bob', 22), (3, 'Charlie', 20), (4, 'Alice', 20), (5, 'David', 18), (6, 'Charlie', 20), (7, 'Eve', 19), (8, 'Bob', 22), (9, 'Frank', 21);