How can I SELECT rows with MAX(Column value), DISTINCT by another column in SQL but with a different table?

Question

How do I do this

but with a different table? Table A has the date and table C has the ID I want to be distinct.

Thanks.

Welcome to Stack Overflow. Please take few moments to take a [tour] and also read [ask] to get better answers for your questions. — Marek Vitek, Jul 12 '17 at 13:58

score 0 · Answer 1 · answered Jul 12 '17 at 14:00

0

use join for that two table and then use distinct.

answered Jul 12 '17 at 14:00

bhumi padodara

score 0 · Answer 2 · answered Jul 12 '17 at 14:09

0

Use GROUP BY statement instead of distinct for this.

SELECT t1.a, MAX(t2.a)
FROM t1
JOIN t2
    ON T1.id = t2.id
GROUP BY T1.a

answered Jul 12 '17 at 14:09

Marek Vitek

2 Answers2