 OT: SQL Question ..., what's the easiest way to ... |
|
|
|
Porsche, and the Porsche crest are registered trademarks of Dr. Ing. h.c. F. Porsche AG.
This site is not affiliated with Porsche in any way. Its only purpose is to provide an online forum for car enthusiasts. All other trademarks are property of their respective owners. |
|
|
| SirAndy |
  Mar 17 2005, 07:11 PM
Post
#1
|
|
Resident German  Group: Admin Posts: 41,679 Joined: 21-January 03 From: Oakland, Kalifornia Member No.: 179 Region Association: Northern California  |
SQL Question:
what's the easiest way to find duplicates in a table? let's say i have a table (tbl_Users) with 20000 rows and the table has a column for the users email addy (sEmail) and i want to list all the accounts that have duplicate email addys. i could run a script that takes each row and runs a count(*) on that addy, but that'll take forever. anything simpler than that ??? (IMG:http://www.914world.com/bbs2/html/emoticons/idea.gif) Andy |
   |
 
|
Posts in this topic
SirAndy OT: SQL Question ... Mar 17 2005, 07:11 PM
Sparky SELECT
-
FROM
tablename
GROU...
Part Pricer I've done this with MySQL tables. I've jus... Mar 17 2005, 07:17 PM john rogers Do it like this:
sqlplus> delete from userID.my_e... Mar 17 2005, 07:20 PM SirAndy <... Mar 17 2005, 07:37 PM Part Pricer Select the entire worksheet. Then go to Data then ... Mar 17 2005, 07:37 PM JB 914 <... Mar 17 2005, 07:38 PM Part Pricer   |
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
|
Lo-Fi Version | Time is now: 10th June 2024 - 05:58 AM |
Invision Power Board
v9.1.4 © 2024 IPS, Inc.
| All rights reserved 914World.com © since 2002 |
|
914World.com is the fastest growing online 914 community! We have it all, classifieds, events, forums, vendors, parts, autocross, racing, technical articles, events calendar, newsletter, restoration, gallery, archives, history and more for your Porsche 914 ... |