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 ?
---------------------------------------------------------------------
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
