If we contrast the original table to our result, we can see that the duplicates were successfully filtered out. However, our result now only shows these values once. If you would like to remove NULL values from the result, you could write the following query:. Look at the following query:. We are looking for unique combinations of these three columns. Executing this query yields the following result:. For example, look at this data:. If we changed the query to the following:.
Asked 9 years, 9 months ago. Active 8 years, 1 month ago. Viewed 14k times. Improve this question. Add a comment.
Active Oldest Votes. Improve this answer. I learned all this by making now, by making a mistake as shown here - stackoverflow. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.
By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy. Popular Course in this category. Course Price View Course. Free Data Science Course. Login details for this Free course will be emailed to you.
0コメント