Re: column filter

"Carl Forsman" <fatwallet951_at_yahoo.com> a écrit dans le message de news: v8igq45d4jo0q81lvr0ja14mv4etd45e9a_at_4ax.com...
| On Fri, 27 Feb 2009 20:37:54 +0100, "Michel Cadot"
| <micadot{at}altern{dot}org> wrote:
|
| >
| >"Carl Forsman" <fatwallet951_at_yahoo.com> a ?crit dans le message de news: 2dfgq4lnlp186te0dcb3hoduur8fu7va2b_at_4ax.com...
| >| The following query will return 3 word in 3 "TABLE COLUMN", How can I
| >| modify the query to return "NO 3 words are the same"?
| >|
| >| the following Table will have duplicated as both row has the same 3
| >| words, I only need "a, young, woman" is enough. I do not need "a,
| >| woman, young"
| >| =======================
| >| a, young, woman <-- both row has same 3 word, I only need 1 row
| >| a, woman, young
| >| =======================
| >| (word1)(word2) (word3)
| >| a, young, woman
| >| a, woman, young
| >| a, fish, dive
| >| ....
| >|
| >| =======================
| >| SELECT DISTINCT A.word As word1, B.word AS word2, C.word AS word3
| >|
| >| FROM Data AS A
| >|
| >| JOIN Data AS B
| >|
| >| ON A.document = B.document
| >|
| >| AND A.position < B.position
| >|
| >| AND ABS(A.position - B.position) < 3
| >|
| >| LEFT JOIN Data AS C
| >|
| >| ON A.document = C.document
| >|
| >| AND A.position <> C.position
| >|
| >| AND C.position <> B.position
| >|
| >| AND (ABS(A.position - C.position) < 3
| >|
| >| OR ABS(B.position - C.position) < 3) order by word1;
| >
| >Use greatest and least functions.
| >
| >Regards
| >Michel
| >
|
| but the query returns 2 row has the same word
|
| (word1)(word2) (word3)
| a, young, woman
| a, woman, young
| a, fish, dive
|
| ===================
| since "a,young,woman" and "a,woman,young" are duplicated
| I only want query return
| (word1)(word2) (word3)
| a, young, woman
| a, fish, dive
|
| -OR-
|
| (word1)(word2) (word3)
| a, woman, young
| a, fish, dive

Yes and try what I have said.
And if you want an example you MUST post a test case: create table and insert statements.

Regards
Michel Received on Fri Feb 27 2009 - 14:32:01 CST