Can I perform group query with the SQL query in SuperMap software?
115EXP 2024.05.17
Can I perform group query with the SQL query in SuperMap software?

1 Answer

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.
242EXP 2024.05.17
...