Infosys SQL Interview Question✅[ Remove Duplicate Records From Table📑In SQL ]

Pubblicato il: 17 settembre 2024
sul canale di: MilEstOne CrEaTor

713

#sql #sqltips #sqlinterview #sqlinterviewquestions #infosys #removeduplicates
Hey, Everyone welcome back. So, today in this video we will learn about
How To Remove Duplicate Records From Table📑In SQL

🟢SQL QUERY USED FOR THIS VIDEO:-
---------------------------------------------------------------------------
CREATE DATABASE TEST;
USE TEST;

CREATE TABLE EMPLOYEE
(
ID Int,
FIRST_NAME varchar(50),
LAST_NAME varchar(50),
[ADDRESS] varchar(50)
);

SELECT * FROM EMPLOYEE;

INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME,[ADDRESS])VALUES (1,'Deepan','Kumar','Odisha');
INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME,[ADDRESS])VALUES (2,'Deepan','Kumar','Odisha');
INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME,[ADDRESS])VALUES (3,'Deepan','Kumar','Odisha');
INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME,[ADDRESS])VALUES (4,'Deepan','Gadkare','Odisha');
INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME,[ADDRESS])VALUES (5,'Niraj','Patel','West_Bengal');
INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME,[ADDRESS])VALUES (6,'Niraj','Patel','West_Bengal');
INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME,[ADDRESS])VALUES (7,'Deepika','Naik','Keral');
INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME,[ADDRESS])VALUES (8,'Ankita','Agarwal','UP');

SELECT * FROM EMPLOYEE;

SELECT * FROM EMPLOYEE;

DELETE FROM EMPLOYEE
WHERE ID NOT IN
(
SELECT MIN(ID) FROM EMPLOYEE
GROUP BY FIRST_NAME,LAST_NAME,[ADDRESS]
)

------------------------------------------
👋 Additional resources
-------------------------------------------

Top 100 Most Commonly Asked SQL Interview Questions and Answers [ Part-1 ] #sql
   • Top 100 Most Commonly Asked SQL Interview ...

Top 100 Most Commonly Asked SQL Interview Questions and Answers [ Part-2 ] #sql
   • Top 100 Most Commonly Asked SQL Interview ...

Introduction To SQL Server [ What is Database ]:-
   • Introduction To SQL Server [ What is Datab...

What is DBMS || Database Management System [ In Hindi ]:-
   • What is DBMS || Database Management System...

What is RDBMS ( Relational Database Management System ):-
   • What is RDBMS ( Relational Database Manage...

Database Recovery From MDF And LDF File Using GUI:-
   • Database Recovery From MDF And LDF File Us...

2 Methods To Create LOGIN In SQL Server:-
   • 2 Methods To Create LOGIN In SQL Server #s...

How To Create a New Login/User In SQL Server:-
   • How To Create a New Login / User In SQL Se...

How To Delete/Drop LOGIN In SQL Server:-
   • How To Delete/Drop LOGIN In SQL Server #sq...

Complete Guide For Import CSV File To #SqlServer Database (Step-By-Step Along With #ERROR & Solution;-
   • Complete Guide For Import #CSV File To #Sq...

🔔 Subscribe to my YouTube channel:-
https://www.youtube.com/channel/UCWfz...

Social Media Link
--------------------------------
LinkedIn:-   / deepan-kumar-patel-777591202
Facebook:- https://www.facebook.com/dipan.patel....
---------------------------------------------------------------------------------------------------------
Thanks for watching...
"Milestone Creator"

In questa pagina del sito puoi guardare il video online Infosys SQL Interview Question✅[ Remove Duplicate Records From Table📑In SQL ] della durata di ore minuti seconda in buona qualità , che l'utente ha caricato MilEstOne CrEaTor 17 settembre 2024, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 713 volte e gli è piaciuto 18 spettatori. Buona visione!

2,048