"alternate" results

[sgtheinz]

Hi there !

I need some help on a query design. Look at this exemple table :

+------+--------+
| id | ville |
+------+--------+
| 1 | Paris |
| 2 | Paris |
| 3 | Paris |
| 4 | Lyon |
| 5 | Lyon |
| 6 | Rennes |
| 7 | Rennes |
+------+--------+

I would like to find a query wich can order the result on the 'ville' col, where items are "alternate".

Like :

+------+--------+
| id | ville |
+------+--------+
| 1 | Paris |
| 4 | Lyon |
| 6 | Rennes |
| 2 | Paris |
| 5 | Lyon |
| 7 | Rennes |
| 3 | Paris |
+------+--------+

Thx !

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886