Add: Special sort querstion

Oh, actually every row of the same id-range has the same 
start_lat/start_lng coordinates as the predecessors end_lat/end_lng 
coordinates. But the question remains the same. Is there a way to do 
something like ORDER BY (start_lat = end_lat AND start_lng = end_lng) ? 
Or maybe another way to achieve the same result?

Dominik Piekarski schrieb:
> Hello everyone,
>
> the following query
> SELECT id, start_lat, start_lng, end_lat, end_lng
> FROM strecken
> WHERE ST_Intersects(strecke, geomfromtext('POLYGON((
> 52.5204252 13.3169317,
> 52.5407887 13.3169317,
> 52.5407887 13.3534097,
> 52.5204252 13.3534097,
> 52.5204252 13.3169317
> ))')) ORDER BY id;
> produces by coincidence the following desired result:
>
> id    start_lat    start_lng    end_lat    end_lng
id range1
> 18074   52.5212087   13.3181119    52.5226187   13.3183479
> 18075   52.5226187   13.3183479    52.5237154   13.3189702
> 18076   52.5237154   13.3189702    52.5244204   13.3201289
> 18077   52.5244204   13.3201289    52.5248120   13.3217812
id range2
> 18095   52.5195701   13.3381855    52.5204710   13.3390224
> 18096   52.5204710   13.3390224    52.5213653   13.3393443
> 18097   52.5213653   13.3393443    52.5219529   13.3395588
> 18098   52.5219529   13.3395588    52.5223511   13.3400846
id range3
> 20293   52.5408279   13.3338833    52.5404625   13.3350205
> 20294   52.5404625   13.3350205    52.5395881   13.3385825
> 20295   52.5395881   13.3385825    52.5387398   13.3447623
>
> Its desired because every single row end_lat and end_lng has the same 
> value as the next row's start_lat and start_lng field (except last one).
> I would like to achieve the same result without using id column inside 
> "order by" clause. Is that possible? How would that query look like?
>