Databases SQL Basics Finding the Data You Want Filtering by Comparing Values

Michelle Clark
Michelle Clark
1,032 Points

I am selecting all columns from the products table (id, name, description, price) but not registering in exercise...

I am selecting all columns from the products table (id, name, description, price) but the exercise continues to give an error message saying I am not selecting all columns.

2 Answers

Steven Parker
Steven Parker
187,496 Points

Usually when the challenge says to "select all columns", it's a hint that you should use the "SELECT *" wildcard instead of specific column names.

Try that, and if that's not it show your complete query code here so we can take a look and give a more precise answer.

Michelle Clark
Michelle Clark
1,032 Points

That is what was needed (the * instead of each column name). Thank you, Steven.

Steven Parker
Steven Parker
187,496 Points

Michelle Clark — Glad to help. You can mark the question solved by choosing a "best answer".
And happy coding!