SQL Editor

Tables and Columns 

Task:

List duplicate pairs of Order records.
This allows a data analyst to decide which row in each pair to delete.
Click here for details on Duplicates.
 
 14 Records
OrderId FirstName LastName OrderNumber OrderDate
163 Lincoln Lincoln 542540 1/10/2013 12:00:00 AM
164 Lincoln Lincoln 542541 1/10/2013 12:00:00 AM
209 Cramer Cramer 542586 2/25/2013 12:00:00 AM
210 Cramer Cramer 542587 2/25/2013 12:00:00 AM
369 Snyder Snyder 542746 7/31/2013 12:00:00 AM
370 Snyder Snyder 542747 7/31/2013 12:00:00 AM
466 Pavarotti Pavarotti 542843 10/22/2013 12:00:00 AM
467 Pavarotti Pavarotti 542844 10/22/2013 12:00:00 AM
591 Izquierdo Izquierdo 542968 1/19/2014 12:00:00 AM
593 Izquierdo Izquierdo 542970 1/19/2014 12:00:00 AM
725 Tonini Tonini 543102 3/24/2014 12:00:00 AM
726 Tonini Tonini 543103 3/24/2014 12:00:00 AM
783 Pavarotti Pavarotti 543160 4/17/2014 12:00:00 AM
784 Pavarotti Pavarotti 543161 4/17/2014 12:00:00 AM
Products
Pricing
Demos
Tutorials
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0