General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>Delete myTable from myTable inner join Dups on myTable.DupKey = Dups.DupKey and myTable.PK > Dups.MinKey
>>
>>can you tell me about the last part? How does the primary key being greater than the minkey granted the minkey stands for minimum key going to help us?
>
>The idea is to remove all duplicates except one. I chose the one with the Min primary key to stay in the table.
urrrg well i have no Primary key but im thinking. is there a way like i could do a count?
like count(mytable.fname) as names having for example having names>1 ann do "x" untill having =1?
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