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 Reporting by Example Day 1: Joining Tables Day 1: Review

Posted by Fairooz Adams
Fairooz Adams
2,704 Points

Quiz Question Issues

This is the question question: What should be added to this query to only return 1 row per employee?

SELECT ______ FIRST_NAME, LAST_NAME FROM EMPLOYEES JOIN ...

1 Answer

Steven Parker
Steven Parker
215,940 Points
Steven Parker
Steven Parker
215,940 Points

Here's a few hints:

  • there's a keyword that prevents the same information from appearing on more than one row
  • the keyword has a meaning similar to the word "unique"
  • the keyword starts with a D and is 8 letters long
Fairooz Adams
Fairooz Adams
2,704 Points

I know we have to use DISTINCT but not sure exactly how.

Steven Parker
Steven Parker
215,940 Points
Steven Parker
Steven Parker
215,940 Points

Try typing that word in the box as the quiz answer.