Databases SQL Reporting by Example Day 1: Joining Tables Day 1: Review

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
146,440 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
146,440 Points

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