Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Regina Ackah
2,649 PointsHow can I query a table to display all columns with missing data?
i was able to query a table to show all columns with missing data.(it had just 4 columns ), id, year_released,title and genre.
this is the query i used "select * from movies where the genre is null or year_released is null ;" i assumed obviously id and title will not have missing values.
In a situation where i have about 10 columns in the data table, do i have to go through same process??, whereby same process i mean, mentioning all ten columns and finding out if it's null, just to run the query??