Dofactory.com
SQL Editor

SQL Self Join Duplicates Example

Tables and Columns 

Task:

Find customers with the same first name (i.e. duplicates)
Click here for details on Self Join.
 
 10 Records
Name Duplicate
Carlos González Carlos Hernández
Carlos Hernández Carlos González
Elizabeth Brown Elizabeth Lincoln
Elizabeth Lincoln Elizabeth Brown
Maria Anders Maria Larsson
Maria Larsson Maria Anders
Paula Parente Paula Wilson
Paula Wilson Paula Parente
Yoshi Tannamuri Yoshi Latimer
Yoshi Latimer Yoshi Tannamuri
Pricing
Jobs
Companies
Products
Demos
Learning
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.