Learn SQL Database Programming

Removing duplicates

To remove a duplicate, let's do some setup first with the following queries:

1. Let's create a copy of the schools table with the following query:

USE lahmansbaseballdb;DROP TABLE IF EXISTS schools_copy;CREATE TABLE schools_copySELECT *FROM schoolsWHERE 1=0;

2. Now, let's insert some data into the schools_copy table with the following query:

USE lahmansbaseballdb;INSERT INTO schools_copy VALUES ('adelphi','Adelphi University','Garden City','NY','USA'),('adelphi1','Adelphi University','Garden City','NY','USA'),('akron','University of Akron','Akron','OH','USA'),('alabama','University of Alabama','Tuscaloosa','AL','USA'),('alabamast','Alabama State University','Montgomery','AL','USA');

3. Now that we have a table set up so ...