How to determine no. of customers if we don't have any index no. Given to them only their account number is available.?

Question

how to approach the problem. any specific keyword or function to determine..?

Answer 1

count unique account numbers

Answer 2

in the same field?

Answer 3

SELECT COUNT(DISTINCT AccountNumber) FROM CUSTOMERS

Answer 4

got it...!!!! 👍👍👍

Answer 5

thanks bro...!

Answer 6

it'll return a list of acc. no with names..🤔