About   -   Contact   -   Purchase   -   Search   -   What's New

Counting Distinct Rows in an Expression
This is a quick tip to show the use of the DISTINCT argument of the Datawindow Count() function. If you have a result set like:
   Row 1: A
   Row 2: A
   Row 3: A
   Row 4: B
   Row 5: C
   Row 6: C

The Count() of the rows would give you 6 but if you wanted the distinct number of values for a column you could code: Count( X for all DISTINCT) where X is the column you are interested in.


Top of Page

Legal Notice

Ken Howe 2011