如何从这个表中选择最新记录(每个order_id仅有一行[最新]):=MAX(order_history_id)
+----------------+--------+-------+----------+
|order_history_id|order_id|trackc |date_added|
+----------------+--------+-------+----------+
| 4400 | 1000 | text | 2014-9-24|
| 4401 | 1001 | text2 | 2014-9-26|
| 4410 | 1000 | text3 | 2014-9-29|
| 4411 | 1003 | text4 | 2014-9-20|
+----------------+--------+-------+----------+
我的当前查询是:
SELECT * FROM order_history WHERE trackc <> '' GROUP BY order_id
trackc
列?如果是,尝试使用ifnull
函数。顺便说一下,我已经编辑了我的答案。 - Hotdin Gurning