help needed about sql statement# Database - 数据库
J*h
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.
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.
