Explain how the DISTINCT keyword effects a SELECT statement that lists two columns in the SELECT clause

The DISTINCT keyword will only suppress duplicate data if the combination of the data in the two columns is duplicated. If the combination of data in the referenced columns is unique for each record in the table, then each record will still be displayed in the results.

Business

You might also like to view...

A drawback of public relations is that is does not reach prospects who prefer to avoid mass media and targeted promotions

Indicate whether the statement is true or false

Business

One disadvantage of the sign test is that it takes into account only a very limited amount of information - namely, the signs of the differences

Indicate whether the statement is true or false

Business