#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2010
    Posts
    10
    Rep Power
    0

    Query ordering question


    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.


    Code:
    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
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2010
    Posts
    10
    Rep Power
    0
    I'll try to explain this a little bit better...Its kind of confusing..


    Basically, I want the query to display the newest name with the newest time with the highest percent first, with all other records of that name to follow that name. Then move onto the next name and do the same thing.

    Its kind of complicated for me to explain...

IMN logo majestic logo threadwatch logo seochat tools logo