How to make a Group By in PostgreSQL with only one field?-CodePudding

Home > Back-end > How to make a Group By in PostgreSQL with only one field?

How to make a Group By in PostgreSQL with only one field?

Time：09-22

SELECT table1.field1, table2.field2 
FROM table1
LEFT JOIN table2 ON table1.field1, table2.field1
GROUP BY table1.field1

MySQL: ✅ All right!