Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Databases

Write a SQL query to answer the following question. What are all the products in the products table? y

Write a SQL query to answer the following question. What are all the products in the products table? Entered everything

The question is misleading. The question should ask for the retrieval of ALL information in the table along with the product / product names, if SELECT * from PRODUCTS; is the only acceptable answer.

3 Answers

Marcelino Jasso
Marcelino Jasso
12,252 Points

I rewatched the video and the answer is SELECT * FROM products;

Hope that helps.

I found this task confusing because the video makes it look like you include the <> around your table name.

SELECT * FROM tablename; is the accurate format : )

Fahad Mutair
Fahad Mutair
10,359 Points

to see whats inside table you have to write this query

SELECT <ColumnName> From <TableName>;

just replace <ColumnName> with the column you want to see

and replace <TableName> with your table in your case products