How to Count Unique Values

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
yahya
Posts: 77
Joined: Sat Jul 16, 2011 6:00 am
Location: South Africa
Contact:

How to Count Unique Values

Post by yahya »

Let’s say you have a list of values where each value is entered more than once.
And now...
You want to count unique values from that list so that you can get the actual numbers of values which are there.

How would one go about implementing this?
AwareIM Developer edition. Version 8.5 (Build 2827) running on Windows Server 2012 R2 Standard
customaware
Posts: 2397
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: How to Count Unique Values

Post by customaware »

Of course you could always use a Stored Procedure if you have a big data set but purely in Aware..... Try This...
CountUnique.zip
(37.94 KiB) Downloaded 421 times
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
Post Reply