This video is the third part of our series on SQL interview questions and answers. This series is specifically designed for people targeting jobs as data analysts, data scientists, data engineers, and business analysts.
In this video, I have explained how to delete duplicate entries in our database using two types of methods
1) Finding the duplicates and deleting the entries
2) Finding the entries to keep and delete the rest of everything
Use the below the commands to create your own database and table:
CREATE DATABASE THEMLMINE;
USE THEMLMINE;
CREATE TABLE emp
(
emp_id INT,
name varchar(20),
age INT,
salary FLOAT
);
INSERT INTO emp VALUES
(102, 'Aviral', 24, 20000),
(103, 'Arohi', 28, 350000),
(104, 'James',35, 120000),
(998, 'Aviral', 24, 20000);
You can download the final script from here: drive.google.com/file/d/1ip2q...
Learn SQL from scratch: • SQL Tutorial for begin...
Instagram: / the_ml_mine
Timestamps:
00:00 Introduction
00:05 Interview question
00:46 MySQL workbench
01:30 Method 1 - Solution 1
06:50 Method 1 - Solution 2
10:30 Temporary tables in MySQL
11:49 Method 2
14:59 Outro
Music credits:
Intro music - Education - upbeat positive (short ver.) by AudioCoffee -- freesound.org/s/724628/
-- License: Attribution NonCommercial 4.0