db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Vatter <thomas.vat...@network-inventory.de>
Subject order by
Date Mon, 27 Feb 2006 23:34:13 GMT

I am too stupid to write an sql 'order by' clause. For 'select 
firstname, lastname ...' I have added 'order by lastname, firstname' and 
have created a composite index on lastname and firstname. I thought the 
result would be an ordering like
Amy    Miller
Bode    Miller
Michael    Miller
Daren    Ralphs
Steven    Ralphs

But what I get is
Michael    Miller
Amy    Miller
Bode    Miller
Daren    Ralphs
Steven    Ralphs

I. e. Micheal is ordered as if it was part of the lastname. I don't 
understand that. Can anybody help me out?

tom


Mime
View raw message