我想按s.no
或time
或无论如何
选择不同的customer_id
顺序
s.no customer_id time
1 3 100001
2 2 100002
3 4 100003
4 3 100004
5 2 100005
我正在使用
select distinct(customer_id) from table_name order by time DESC
它给出了4 2 3
答案,但正如我所希望的那样,它应该是2 3 4
所以你的问题陈述是"你想要customer_id的列表,从它们的最大时间值开始按降序排序",对吧?
SELECT customer_id, MAX(time)
FROM table_name
GROUP BY customer_id
ORDER BY MAX(time) DESC
你必须像这样做第二个选择:
SELECT
`number`
FROM
(
SELECT
DISTINCT(number) AS number
FROM
`table_name`
ORDER BY
`time` DESC
) AS `temp`
ORDER BY
`number` ASC
可以使用第二个查询来完成
$query = "SELECT *
FROM (SELECT customer_id
FROM table_name
ORDER BY customer_id DESC) as rows
GROUP BY customer_id";