Query ordering question

Поиск
Список
Период
Сортировка
От ajmcello
Тема Query ordering question
Дата
Msg-id CANuED-M7uToVenjfoK55W-3V6hhFap9p06PHYvKrjFSTbw5-AQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Query ordering question  ("David Johnston" <polobo@yahoo.com>)
Re: Query ordering question  (Alban Hertroys <haramrae@gmail.com>)
Список pgsql-general
I'm interested in sorting my query by time descending, with the
highest percent by latest time shown first, and then every other
record associated with column name sorted by time descending,
following the first record. Does that make sense?

The first query is the best I've come up with. The second, is how I'd
like it took.

Any suggestions?

Thanks in advance.

db=# SELECT name,date,percent,price,time,amount FROM name WHERE amount
>= '1000000' AND date='$today' ORDER BY percent DESC;

 name |    date     | percent        |  price  |   time   |  amount
--------+------------+----------------+---------+----------+----------
 BOB   | 2012-07-02 |          63.77 |    8.86 | 14:59:00 | 26975372
 BOB   | 2012-07-02 |          63.77 |    8.86 | 15:01:00 | 27001372
 BOB   | 2012-07-02 |          64.06 |  8.8755 | 15:04:00 | 27145552
 BOB   | 2012-07-02 |          63.77 |    8.86 | 14:57:00 | 26946338
 GIL   | 2012-07-02 |          38.72 |  0.6789 | 14:55:00 |  1012880
 GIL   | 2012-07-02 |          38.74 |   0.679 | 14:59:00 |  1026190
 GIL   | 2012-07-02 |          38.74 |   0.679 | 14:57:00 |  1017480
 GIL   | 2012-07-02 |          38.95 |    0.68 | 15:01:00 |  1027590
 BUB   | 2012-07-02 |           22.8 |  4.1262 | 14:57:00 |  7300694
 BUB   | 2012-07-02 |          22.02 |     4.1 | 14:59:00 |  7346968
 BUB   | 2012-07-02 |          22.47 |   4.115 | 15:01:00 |  7371456
 BUB   | 2012-07-02 |          22.02 |     4.1 | 15:04:00 |  7406511
 BUB   | 2012-07-02 |          23.84 |  4.1611 | 14:55:00 |  7221402
 SAL   | 2012-07-02 |           21.5 |  41.335 | 15:02:00 | 71965920
 SAL   | 2012-07-02 |           21.5 |  41.335 | 15:05:00 | 71986544
 SAL   | 2012-07-02 |           21.5 |  41.335 | 15:00:00 | 71943280
 SAL   | 2012-07-02 |          21.52 |   41.34 | 14:55:00 | 71903096
 SAL   | 2012-07-02 |           21.5 |  41.335 | 14:58:00 | 71921496

 name |    date     | percent        |  price  |   time   |  amount
--------+------------+----------------+---------+----------+----------
 BOB   | 2012-07-02 |          64.06 |  8.8755 | 15:04:00 | 27145552
 BOB   | 2012-07-02 |          63.77 |    8.86 | 15:01:00 | 27001372
 BOB   | 2012-07-02 |          63.77 |    8.86 | 14:59:00 | 26975372
 BOB   | 2012-07-02 |          63.77 |    8.86 | 14:57:00 | 26946338
 BOB   | 2012-07-02 |          63.96 |    8.87 | 14:55:00 | 26935038
 GIL   | 2012-07-02 |          38.95 |    0.68 | 15:01:00 |  1027590
 GIL   | 2012-07-02 |          38.74 |   0.679 | 14:59:00 |  1026190
 GIL   | 2012-07-02 |          38.74 |   0.679 | 14:57:00 |  1017480
 GIL   | 2012-07-02 |          38.72 |  0.6789 | 14:55:00 |  1012880
 BUB   | 2012-07-02 |          22.02 |     4.1 | 15:04:00 |  7406511
 BUB   | 2012-07-02 |          22.47 |   4.115 | 15:01:00 |  7371456
 BUB   | 2012-07-02 |          22.02 |     4.1 | 14:59:00 |  7346968
 BUB   | 2012-07-02 |           22.8 |  4.1262 | 14:57:00 |  7300694
 BUB   | 2012-07-02 |          23.84 |  4.1611 | 14:55:00 |  7221402
 SAL   | 2012-07-02 |           21.5 |  41.335 | 15:05:00 | 71986544
 SAL   | 2012-07-02 |           21.5 |  41.335 | 15:02:00 | 71965920
 SAL   | 2012-07-02 |           21.5 |  41.335 | 15:00:00 | 71943280
 SAL   | 2012-07-02 |           21.5 |  41.335 | 14:58:00 | 71921496
 SAL   | 2012-07-02 |          21.52 |   41.34 | 14:55:00 | 71903096

В списке pgsql-general по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute
Следующее
От: "David Johnston"
Дата:
Сообщение: Re: Query ordering question