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

Databases

Dominik Singer
Dominik Singer
3,528 Points
Posted by Dominik Singer
Dominik Singer
3,528 Points

What am i doing wrong?

Hey There,

i receive the error "Not all Columns selected"

Waht am i doing wrong?

best,

Dominik

Ken Alger
Ken Alger
Treehouse Teacher
Ken Alger
Ken Alger
Treehouse Teacher

Can you show what SQL statement you tried?

Maximiliane Quel
Maximiliane Quel
Courses Plus Student 55,489 Points
Maximiliane Quel
Maximiliane Quel
Courses Plus Student 55,489 Points

Hi Dominik,

did you find a solution?

Unfortunately, we cannot see your challenge or the code that you tried to use, so you need to give us a little more information, by posting your code and, for extra convenience, including information and a link to the challenge you tried.

1 Answer

Steven Parker
Steven Parker
231,261 Points
Steven Parker
Steven Parker
231,261 Points

As others have pointed out, it is difficult to know exactly what went wrong without knowing which challenge you were working on and what code you entered. But I can give you some general hints:

"All columns" is generally represented by the asterisk (*) symbol. So it's possible that your answer was expected to include, at least in part, this construct:

SELECT * FROM your_table

The other possibility that comes to mind is if the challenge specifically named things you were supposed to select but you missed one or more. For example, if the table included columns first_name, last_name, age (among other things); and the challenge asked you to "select the full name of each person over 21", you would need to say:

SELECT first_name, last_name FROM people WHERE age > 21;

Hopefully these hints will get you going. If not, please amend your question and add the specific challenge and your response.