MapInfo Pro

MIP query (SQL) to count / frequency of every feature in a string field -> output the counts of each unique feature

  • 1.  MIP query (SQL) to count / frequency of every feature in a string field -> output the counts of each unique feature

    Posted 07-22-2021 22:03

    What I'm trying to achieve in MIP a query (SQL) to count / frequency of every feature in a string field

     If we take a field called 'BOH_HistLith' (string field) I want to count each of the features in the field 

     Outcome would be how many/count of e.g.

     

    Tlr = ?

    Tls = ?

    Au =?
    And etc


    The Calc Column statistic only works for integers

    Would anyone please assist with a suggestion /script to use in MIP SQL query for this task?

     Cheers, Mike

     



    ------------------------------
    Mike Woodbury
    Knowledge Community Shared Account
    ------------------------------