help needed about sql statement - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

help needed about sql statement

help needed about sql statement# Database - 数据库

J*h2005-03-01 08:03

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*m2005-03-01 08:03

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.