duplict fields

[joby]

Please see the query

select distinct city,numb from res where id=10 and _date='2008-05-02' order by numb,city;

out put is

city | numb
---------------+---------------
DELHI | 10
DELHI | 11
AGRA | 12

I want to avoid duplicate cities .(DELHI)

That is the out put will be

city |
------------------
DELHI |
AGRA |

Make sure DELHI will be in the first record . because its numb is less than that of AGRA.

How to rewrite the query.

[chazzy]

what about...

select city,min(numb) as numb from res where id=10 and _date='2008-05-02' group by city order by numb,city;


?

[joby]

Thank u. It is working fine.
but I want to display only cites.

[chazzy]

you always display exactly what the query returns?

anyways, you could just drop the column in the column clause...