Question #76379

What is the query below retrieving?

SELECT CUSTOMER_STATE

FROM CUSTOMER_T

GROUP BY CUSTOMER_STATE

HAVING COUNT(*) = 1



record for CUSTOMERID = 1


States with more than 1 customer


States with one customer


States with ID = 1

Expert's answer

Answer:
- States with one customer

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

LATEST TUTORIALS
APPROVED BY CLIENTS