Re: SQL puzzle...

From: Noel <tomekb_at_softman.pl>
Date: Wed, 9 Jun 2004 13:49:10 +0200
Message-ID: <ca6tei$59b$1@inews.gazeta.pl>

> 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
> --

select * from graphe
where end > start
order by 1;

--
TomekB

Received on Wed Jun 09 2004 - 06:49:10 CDT