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 SQL Basics Getting Data from a Database Retrieving Specific Columns of Information

Posted by Dilwar Rahman
Dilwar Rahman
3,750 Points

We're still in the e-commerce database. This time, from the products table, get the name of every product.

can anyone help me out with this query

2 Answers

Steven Parker
Steven Parker
216,057 Points
Steven Parker
Steven Parker
216,057 Points

You've already passed a harder challenge task. For this one, you just need to select the column named "name" from the table named "products".

Give it a shot, and if you still have trouble, show your complete query code here for more specific help.

Dilwar Rahman
Dilwar Rahman
3,750 Points

Hi, sorry i am still having trouble not really sure what to do. thanks

Steven Parker
Steven Parker
216,057 Points
Steven Parker
Steven Parker
216,057 Points

You already passed task 1 to get to task 2, try doing this task in a similar way to how you did task 1. Give it your best shot and if you still have trouble, show the query you are trying here.

Dilwar Rahman
Dilwar Rahman
3,750 Points

alright the answer i got was SELECT name AS "Product Name", description AS "Product Description" FROM products; but this was incorrect and i tried many variations but still cannot get this

Steven Parker
Steven Parker
216,057 Points
Steven Parker
Steven Parker
216,057 Points

You're working too hard, and getting more data than the instructions ask for. Remember, the task here is "from the products table, get the name of every product".

So you don't need the description at all, and you don' t need a column alias.

Dilwar Rahman
Dilwar Rahman
3,750 Points

Hi, I have also tried SELECT Product_name From products table; and many like this but don't seem to get any luck.

Steven Parker
Steven Parker
216,057 Points
Steven Parker
Steven Parker
216,057 Points

There's no "Product_name" column in the "products" table. The column that the instructions ask you to select is "name", And when you identify a table, you use only it's name without the word "table".

I'll bet you can get it now.

Dilwar Rahman
Dilwar Rahman
3,750 Points

Oh ok so would it be SELECT name FROM Product

Steven Parker
Steven Parker
216,057 Points
Steven Parker
Steven Parker
216,057 Points

You're very close! But the name of the table is "products" (with an "s").

Dilwar Rahman
Dilwar Rahman
3,750 Points

Thanks for your help Steven.

harshayraipancholi
seal-mask
.a{fill-rule:evenodd;}techdegree
harshayraipancholi
Front End Web Development Techdegree Student 16,748 Points
harshayraipancholi
.a{fill-rule:evenodd;}techdegree
harshayraipancholi
Front End Web Development Techdegree Student 16,748 Points

Hi Guys,

I'm having a similar problem, what am I missing in my code :

select name from products;

Steven Parker
Steven Parker
216,057 Points
Steven Parker
Steven Parker
216,057 Points

Instead of posting a question as an "answer" to another one, you should always start a fresh question and include both your complete code and a link to the course page. The code inclusion and links should be done automatically by using the "Get Help" button in a challenge to create the question.