spendius_at_muchomail.com (Spendius) wrote in message news:<aba30b75.0406090235.7842a055_at_posting.google.com>...
> I have a table containing
> --select * from graphe
> --order by 1,2
> --/
> -- START END VALUE
> -- ---------- ---------- ----------
> -- 2376 2377 3659
> -- 2377 2376 3659
> -- 2377 2399 3755
> -- 2378 2399 3005
> -- 2378 2390 6273
> -- 2390 2378 6273
> -- 2390 2552 2775
> -- 2399 2377 3755
> -- 2399 2378 3005
> -- 2552 2390 2775
> --
> --10 rows selected.
> As you can see, the relationships between START and END are
> recorded twice.
> I'd like to get with a simple -?- SELECT statement the following:
> -- START END VALUE
> -- ---------- ---------- ----------
> -- 2376 2377 3659
> -- 2377 2399 3755
> -- 2378 2390 6273
> -- 2390 2552 2775
> -- 2399 2378 3005
How about adding: WHERE start < end ?
Received on Wed Jun 09 2004 - 10:56:40 CDT
