Re: ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz) - Mailing list pgsql-general

On Tue, 10 May 2005 07:41 pm, Julian Legeny wrote:
> Hello,
>
>    I have following problem:

> But I would like to sort all data as following:
>
>    NAME
> -----------
>    AAA
>    aaa
>    BBB
>    bbb
>    CCC
>    ccc
>
>
> How can I write sql command (or set up ORDER BY options) for selecting that?
>
SELECT * FROM MY_TABLE ORDER BY lower(NAME), NAME

The second NAME is to ensure that AAA comes before aaa, otherwise the order is undetermined.