>I have this tables :
>
>mysql>select * from bid_history;
>+-----------+----------------+---------+-------+----------+-------------+
>| domain_id | bid_time | user_id | price | bid_type | proxy_price |
>+-----------+----------------+---------+-------+----------+-------------+
>| 1 | 20010501035942 | 2 | 10.00 | 1 | 10.00 |
>| 1 | 20010501035952 | 3 | 10.00 | 1 | 10.00 |
>| 1 | 20010501035956 | 4 | 10.00 | 1 | 10.00 |
>| 1 | 20010501040628 | 5 | 11.00 | 1 | 11.00 |
>| 2 | 20010501052520 | 2 | 10.00 | 1 | 10.00 |
>| 2 | 20010501052529 | 3 | 10.00 | 1 | 10.00 |
>| 1 | 20010501052542 | 2 | 11.00 | 1 | 11.00 |
>| 2 | 20010501052655 | 2 | 12.00 | 1 | 12.00 |
>| 1 | 20010501052542 | 3 | 11.00 | 1 | 11.00 |
>+-----------+----------------+---------+-------+----------+-------------+
>
>mysql> select domain_id , domain_name from domain;
>+-----------+-------------+
>| domain_id | domain_name |
>+-----------+-------------+
>| 1 | iwan |
>+-----------+-------------+
>
>I have doing this query (but the results don't satisfied me) :
>mysql>select b.domain_id, b.user_id , max(b.price) as mb , b.bid_time ,
>a.domain_name , a.minimum_price from domainplayer_bid_history as b ,
>domainplayer_domain as a where a.domain_id = b.domain_id group by
>b.domain_id , b.user_id , b.bid_time order by b.domain_id , mb desc ,
>b.bid_time asc ;
>+-----------+---------+-------+----------------+-------------+--------------
>-+
>| domain_id | user_id | mb | bid_time | domain_name | minimum_price
>|
>+-----------+---------+-------+----------------+-------------+--------------
>-+
>| 1 | 5 | 11.00 | 20010501040628 | iwan | 10.00
>|
>| 1 | 2 | 11.00 | 20010501052542 | iwan | 10.00
>|
>| 1 | 3 | 11.00 | 20010501052542 | iwan | 10.00
>|
>| 1 | 2 | 10.00 | 20010501035942 | iwan | 10.00
>|
>| 1 | 3 | 10.00 | 20010501035952 | iwan | 10.00
>|
>| 1 | 4 | 10.00 | 20010501035956 | iwan | 10.00
>|
>+-----------+---------+-------+----------------+-------------+--------------
>-+
>
>I want the query's result :
>+-----------+---------+-------+----------------+-------------+--------------
>-+
>| domain_id | user_id | mb | bid_time | domain_name | minimum_price
>|
>+-----------+---------+-------+----------------+-------------+--------------
>-+
>| 1 | 5 | 11.00 | 20010501040628 | iwan | 10.00
>|
>| 1 | 2 | 11.00 | 20010501052542 | iwan | 10.00
>|
>| 1 | 3 | 11.00 | 20010501052542 | iwan | 10.00
>|
>| 1 | 4 | 10.00 | 20010501035956 | iwan | 10.00
>|
>+-----------+---------+-------+----------------+-------------+--------------
>-+
>
>How to do this in mysql ?
Sir, don't group on bid_time.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
MySQL list magic words: sql query database
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
