我試圖u.u_id在我的資料庫表中隱藏重復項。我嘗試使用該SELECT DISTINCT陳述句，但它沒有隱藏。有人能幫我嗎？謝謝！
SELECT DISTINCT u.u_id, l.l_id, u.fname, u.mname, u.lname, u.dept, u.user_type, u.u_grdsec, e.e_name, l.date_added, DATE(l.date_added)
FROM logs l
INNER JOIN users u ON l.u_id = u.u_id
INNER JOIN establishment e ON l.e_id = e.e_id
WHERE DATE(l.date_added) = CURDATE()
ORDER BY l.date_added DESC;
這是我的 LOGS 表
這是上面陳述句的結果
的預期結果u_id是這樣的
------
| u_id |
------
| 48 |
| 47 |
| 57 |
| 60 | <-- hide the other 60 row
| 71 |
| 66 | <-- hide the other 66 row
| 83 |
| 58 |
| 56 |
| 61 |
| 59 |
| 90 |
| 91 |
| 68 |
------
解決方案：
SELECT l.l_id, u.fname, u.mname, u.lname, u.dept, u.user_type, u.u_grdsec, e.e_name, l.date_added, DATE(l.date_added), date_format(l.date_added, '%H:%i') as 'time'
FROM logs l INNER JOIN users u ON l.u_id = u.u_id
INNER JOIN establishment e ON l.e_id = e.e_id
WHERE DATE(l.date_added) = CURDATE()
GROUP BY
date_format(l.date_added, '%H:%i'), l.u_id
ORDER BY l.date_added DESC
uj5u.com熱心網友回復：
按 i.u_id 分組或應用左連接
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/453105.html
標籤：mysql