Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: samusprime
- Order by date
-
How do you delete the first of two similar (not dupes) record?
Nothing in the table can determine which value is wrong. All that is known is that all of the incorrect records were entered first. The correcting records were entered after (that is why there are a pair for every error. I'm kind of hoping there is a way the system can recognize which record (of...- samusprime
- Post #3
- Forum: ANSI_SQL
-
How do you delete the first of two similar (not dupes) record?
I have this table (ItemsSold) with 1000 record. It contains these records: Date Product Type Gallons 1/12/2005 Milk Dairy 4253 1/12/2005 2% Milk Diary 6343 1/13/2005 10% Juice Mix Juices 3245 1/13/2005...- samusprime
- Thread
- Replies: 3
- Forum: ANSI_SQL
