Question

Which of the following queries would check for duplicates of a customer id, their complete addresses and totals in the invoice table, and how many there are of each?

a.) Select billing address, billing city, billing state, billing country, billing postal code, total, customer id from invoice group by billing address, billing city, billing state, billing country, billing postal code, total, customer id having count(*) > 1;

b.) Select billing address, billing city, billing state, billing country, billing postal code, total, customer id, count() from invoice group by billing address, billing city, billing state, billing country, billing postal code, total, customer id having count() > 1;

c.) Select , count() from invoice group by * having count(*) > 1;

d.) Select customer id, count() from invoice group by customer id having count() > 1;

Answer 1

To check for duplicates of a customer id, their complete addresses, and totals in the invoice table and determine how many there are of each, use option d.) Select customer id, count() from invoice group by customer id having count() > 1;

Step-by-step explanation:

The correct query to check for duplicates of a customer id, their complete addresses, and totals in the invoice table, and how many there are of each is option d.) Select customer id, count() from invoice group by customer id having count() > 1;