I am unclear on exactly on,
SELECT DISTINCT col1, col2, ... FROM table_name
When called on one column it gives back only distinct values of that column. What happens when we use it with multiple columns and should we ever do this?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
How does this work exactly?
It gives you distinct combinations of all the expression in the
SELECT DISTINCT col1, col2, ... FROM table_name ;
is also equivalent to:
SELECT col1, col2, ... FROM table_name GROUP BY col1, col2, ... ;
Another way to look at how it works - probably more accurate - is that it acts as the common bare
ALL) and then removes any duplicate rows. See Postgres documentation about
Should we ever do this?
Of course. If you need it, you can use it.