Using the customers table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level. Which…

The correct answer is C. Option C. Unless you indicate otherwise, SQL displays the results of a query without eliminating the To eliminate duplicate rows in the result, include the DISTINCT keyword in the SELECT clause immediately after the SELECT keyword. You can specify multiple columns after the DISTINCT…

Reporting Aggregated Data using the Group Functions

Question

Using the customers table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level. Which query would give the required result?

Exhibit

Options

AOption A
BOption B
COption C
DOption D

How the community answered

(47 responses)

A
4% (2)
B
11% (5)
C
81% (38)
D
4% (2)

Explanation

Unless you indicate otherwise, SQL displays the results of a query without eliminating the To eliminate duplicate rows in the result, include the DISTINCT keyword in the SELECT clause immediately after the SELECT keyword. You can specify multiple columns after the DISTINCT qualifier. The DISTINCT qualifier affects all the selected columns, and the result is every distinct combination of the columns.

Topics

#DISTINCT#aggregate functions#credit limit#income level

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice