var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help with Count
I have a table that has Order Number and an Account Number, I want to count all the account numbers. However there might be more then one order number with the same account number...
[Order Number] [Account Number]
Output should be: 4
I want to count([account number]) and get 4, notice there are 5 rows, the 1st and last have the same account number.
How do I write this query?
Found the anwser I was looking for!
select count(distinct [account number]) from table
select count(distinct [Account Number])
Good timing! I found the answer just as you posted!
Thanks for the reply!