J*****h
发帖数: 10 | 1 my table is like this:
lineID sub1 sub2 sub3
How can I get the distinct value of sub1 , sub2 and sub3?
Each column of Sub1, sub2 , sub3 has duplicate values.
And there are duplicate values between sub1, sub2 and sub3.
Thank you in advance. | n**m
发帖数: 255 | 2 SELECT DISTINCT SUB1 SUB2 SUB3 FROM T
【在 J*****h 的大作中提到】
: my table is like this:
: lineID sub1 sub2 sub3
: How can I get the distinct value of sub1 , sub2 and sub3?
: Each column of Sub1, sub2 , sub3 has duplicate values.
: And there are duplicate values between sub1, sub2 and sub3.
: Thank you in advance.
| s******n
发帖数: 45 | 3 R u expecting one column in your return results, or 3 columns? Hehe...
【在 n**m 的大作中提到】
: SELECT DISTINCT SUB1 SUB2 SUB3 FROM T
| J*****h
发帖数: 10 | 4 one column.
【在 s******n 的大作中提到】
: R u expecting one column in your return results, or 3 columns? Hehe...
|
|
