搜索別名的正確方法是什么？在下面的代碼中，我創(chuàng)建了一個(gè)名為 (USER) 的別名，在此列中，我收集了 (DE) 和 (PARA) 列中的所有值。(SELECT *, de as user FROM mensagens WHERE user = '1' GROUP BY projeto ORDER BY data DESC) UNION(SELECT *, para as user FROM mensagens WHERE user = '1' GROUP BY projeto ORDER BY data DESC)SQL在線：http ://sqlfiddle.com/#!9/d506b7/2
1 回答
呼如林
TA貢獻(xiàn)1798條經(jīng)驗(yàn) 獲得超3個(gè)贊
你可以做
select * from
(
SELECT *, de as user FROM mensagens
UNION
SELECT *, para FROM mensagens
) tmp
where user = 1
GROUP BY projeto
ORDER BY data DESC
或者更簡(jiǎn)單：
SELECT *
FROM mensagens
WHERE 1 in (de, para)
GROUP BY projeto
ORDER BY data DESC
- 1 回答
- 0 關(guān)注
- 76 瀏覽
添加回答
舉報(bào)
0/150
提交
取消