b****r
发帖数: 113 | 1 In this talbe, each line is in this format:
ID, Name
1, abc
2,de
3,abc -------duplicate
4,de -------duplicate
5,gg
.
.
.
ID is the primary key. How to find and delete any possilbe duplicates of
"Name"? Thanks in advance. | c***y
发帖数: 114 | 2 select distinct name
【在 b****r 的大作中提到】
: In this talbe, each line is in this format:
: ID, Name
: 1, abc
: 2,de
: 3,abc -------duplicate
: 4,de -------duplicate
: 5,gg
: .
: .
: .
| b****r
发帖数: 113 | 3 i c, thanks a lot.
【在 c***y 的大作中提到】
: select distinct name
|
|
