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 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
229,670 Points
Steven Parker
Steven Parker
229,670 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
229,670 Points
Steven Parker
Steven Parker
229,670 Points

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