0

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

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

26th Jun 2017, 6:56 AM
Saurabh Sharma
Saurabh Sharma - avatar
6 Antworten
+ 2
count unique account numbers
26th Jun 2017, 6:57 AM
jay
jay - avatar
+ 2
in the same field?
26th Jun 2017, 7:01 AM
jay
jay - avatar
+ 2
SELECT COUNT(DISTINCT AccountNumber) FROM CUSTOMERS
26th Jun 2017, 7:04 AM
jay
jay - avatar
+ 1
got it...!!!! 👍👍👍
26th Jun 2017, 7:04 AM
Saurabh Sharma
Saurabh Sharma - avatar
+ 1
thanks bro...!
26th Jun 2017, 7:15 AM
Saurabh Sharma
Saurabh Sharma - avatar
0
it'll return a list of acc. no with names..🤔
26th Jun 2017, 6:59 AM
Saurabh Sharma
Saurabh Sharma - avatar