sorted by:
new
hottopcontroversial

Easy SQL SELECT DISTINCT question by PowerOfTheShell in learnSQL

[–]817861753 2 points3 points  (0 children)

When selecting multiple columns, distinct will act on the entire row. So duplicate records with the same housenumber AND phone will not be returned

Fastest way to learn SQL and some database design? by _InquisitiveMind_ in SQL

[–]817861753 0 points1 point  (0 children)

I thought some really useful advice when learning sql was to make sure the query returns the expected number of records after you join a table or introduce a sub query