Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting duplicate records
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Deleting duplicate records
Miscellaneous
Thread ID:
00949847
Message ID:
00949847
Views:
47
My program had a bug and when inserted duplicate records. What SQL can I use to delete all the duplicates, but one?

To find the duplicates I would use the sql below, but only want where cnt_text > 1. Then I want to delete all the records but the lowest sequence number (seq).

select key, seq, desc, comp_dt, count(text) as cnt_text from tickler ;
where desc = "Letter" and comp_dt = date()-1 ;
order by key, seq ;
group by key

thanks
Next
Reply
Map
View

Click here to load this message in the networking platform