You wrote:
I have a table with some 6300 records. I'm trying to use a SQL
Select to obtain a count of how many discrete values the column
contains. FYI, it's a text field that contains 2-letter U.S.
State abbreviations.
It would be real handy to do this rather than my just sorting on
that column and then counting by hand.
Answer:
You can perform a select statement with a group by and the resulting
browser will represent the unique values. The total number of records is
your count of discrete values in the column.
For example:
Select * from tablename group by columname
Tablename is the name of your table and columname is the name of your
column that you are trying to determine the discrete values on.
Cindy
MapInfo Technical Support
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
