General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Huh? I know, its a strange subject line. Here's my problem. Through something of a snafu we have about 600 records in a table that are improper duplicates of other records. We want to remove them. This would be easy with select distinct EXCEPT that one field "sequence" was provided to create a unique sequence number for each record. So, they are all distinct because they all have different sequence numbers. I can get around this by selecting into a cursor, deleting the sequence numbers, and then selecting dist from the cursor. This gives me the truly distinct records albeit without the sequence numbers. Now I need to put the original sequence numbers back. Any ideas on how to do this?
>
>
>Can you do something like:
>
>Select max(seqfield), field1, field2, field3, etc from table into cursor crsrname group by field1, field2, field3, etc
>
>Will that give you your distinct records?
On the surface at least that seems to work. Thank you very much. I've never really understood the GROUP BY clause. Is there a simple explanation for dummies of what it does?
Thanks again
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only