Re: SQL puzzle...

    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

The first row shows start > end, but the 5th row shows start < end, what is your criteria for choosing?

Plus, how did the data get this way in the first place?

-- 
Galen Boyer