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
--
--5 rows selected.
i.e. get rid of this redundant information.
Someone has a solution perhaps ?
Thanks much !
Regards,
Sp
Received on Wed Jun 09 2004 - 05:35:47 CDT
