ORDER BY Clause
От | Derrick Betts |
---|---|
Тема | ORDER BY Clause |
Дата | |
Msg-id | 48017576.6070607@blueaxis.com обсуждение исходный текст |
Ответы |
Re: ORDER BY Clause
|
Список | pgsql-novice |
I have a query: SELECT fruit, group_number, ordering_number FROM fruit_groups ORDER BY group_number, order_number; The results look like: fruit | group_number | ordering_number --------+------------------+------------------- cherry | 1 | 1 orange | 1 | 2 apple | 2 | 1 pear | 2 | 2 banana | 3 | 1 kiwi | 3 | 2 I would like the results to look like: fruit | group_number | ordering_number --------+------------------+------------------- apple | 2 | 1 orange | 2 | 2 banana | 3 | 1 kiwi | 3 | 2 cherry | 1 | 1 orange | 1 | 2 I want the group_number to be grouped together, then sorted by the ordering_number, then listed in the output alphabetically by the fruit name listed first in the group_number (as defined by the ordering_number). Does anyone know how I might modify my statement to get this ordering? Thanks, Derrick
В списке pgsql-novice по дате отправления: