Php sql DISTINCT行id没有重复

Question

SELECT DISTINCT buyer,caseid,subject,service FROM s_support  
ORDER BY id DESC

result is

buyer               subject          service    caseid
[e-mail] ---- I need help ---- Other ---- 438613
[e-mail] ---- Urgent      ---- Other ---- 438612
[e-mail] ---- Help        ---- Other ---- 438611

I want to view id in DISTINCT How? I wants to hide the duplicates to keep only one row per buyer/subject/service/case but keep a row ID.

id  buyer               subject          service    caseid
9   [e-mail] ---- I need help ---- Other ---- 438613
7   [e-mail] ---- Urgent      ---- Other ---- 438612
6   [e-mail] ---- Help        ---- Other ---- 438611

Answer 1

The question is unclear but you are probably looking for this.

Try both of those in your mysql_query() and keep the one that fits your need (if any)

---

Eliminate duplicates and keep the lowest ID

     SELECT MIN(id) AS id, buyer,caseid,subject,service 
     FROM s_support 
     GROUP BY buyer,caseid,subject,service
     ORDER BY id DESC

---

Eliminate duplicates and keep the highest ID

     SELECT MAX(id) AS id, buyer,caseid,subject,service 
     FROM s_support 
     GROUP BY buyer,caseid,subject,service
     ORDER BY id DESC

If not, rewrite that question in an intelligible manner :)