[ad_1]
Try this.
SELECT *, max(DUP_NUMBER) as dup FROM table1 where CONTACTS=1 GROUP BY FIELD_A ORDER BY date LIMIT 3
[ad_2]
solved How can I merge these mysql statements [closed]
[ad_1]
Try this.
SELECT *, max(DUP_NUMBER) as dup FROM table1 where CONTACTS=1 GROUP BY FIELD_A ORDER BY date LIMIT 3
[ad_2]
solved How can I merge these mysql statements [closed]