A Practical Guide to SQL and Database Fundamentals/

...

/

Quiz: Data Retrieval

Quiz: Data Retrieval

Test your knowledge of SQL syntax.

We'll cover the following...

Query syntax and data retrieval

1.

Consider the following syntax. How does the INNER JOIN clause work?

SELECT DISTINCT TOP ColumnName,
       MAX(Column_Name)
FROM FirstTable
       INNER JOIN SecondTable
          ON First_Table.ColumnName = Second_Table.Column_Name
WHERE Condition
GROUP BY ColumnName
ORDER BY ColumnName ASC/DESC
A.

It extracts records that are not common between FirstTable and SecondTable.

B.

It extracts the matching records between FirstTable and SecondTable.

C.

It extracts all the records from the top three rows.

D.

None of the above.

1 / 4