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

Fairooz Adams
Fairooz Adams
2,704 Points
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
150,186 Points
Steven Parker
Steven Parker
150,186 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
Fairooz Adams
Fairooz Adams
2,704 Points

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

Steven Parker
Steven Parker
150,186 Points
Steven Parker
Steven Parker
150,186 Points

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