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

OMKAR POOJARI
OMKAR POOJARI
6,352 Points
Posted by OMKAR POOJARI
OMKAR POOJARI
6,352 Points

Write the SQL to retrieve all customer information from the users table.

how to retrieve customer from users

2 Answers

Tim Knight
Tim Knight
28,888 Points
Tim Knight
Tim Knight
28,888 Points

Hi Omkar,

I'm guessing you're on Question 2 of 5 in the code challenge for selecting all information from a table.

"Write the SQL to retrieve all customer information from the users table."

The way they've styled the word "users" tells you that's the name of the table that you want to get all of the information from. So you first tell SQL what you want to select in this case, everything or *.

SELECT *

Then you add from which table you want to select everything from and end your statement with a semi-colon.

SELECT * FROM users;