Q: Can I perform group query with the SQL query in SuperMap software?

A: At present, only the attribute query of SuperMap software supports group query, and the spatial query does not support group query currently. The query statement for attribute query is the same as the standard sql query statement. For example, if you want to query the lowest scores of all the subjects among all students, you can use the statement as follows: SELECT table.name, table.subject, min (table.score) as minScore FROM table GROUP by table.name.

09 Jul,2019

More iDesktop FAQ