Question
I want to count the unique values in a column in a table on MS Access. So far i have SELECT COUNT (*) AS Total
I want to count the unique values in a column in a table on MS Access. So far i have
SELECT COUNT (*) AS Total
FROM (SELECT DISTINCT Company_id FROM statements) AS T
how do i correctly do this? Please provide the SQL code for access to count unique values
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Intelligent Information And Database Systems Second International Conference Acids Hue City Vietnam March 2010 Proceedings Part 1 Lnai 5990
Authors: Manh Thanh Le ,Jerzy Swiatek ,Ngoc Thanh Nguyen
2010th Edition
3642121446, 978-3642121449
