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

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
177,587 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

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

Steven Parker
Steven Parker
177,587 Points

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