Monthly Archives: November 2019

Home/2019/November

Important SQL Tricks for GIS

By |2019-11-19T13:39:42-06:00November 19th, 2019|Uncategorized|

Basic SQL Structure SELECT * FROM Table; This is as simple as it gets. Simple Query SELECT ID, NAME FROM Table WHERE ID = 3;   Finding Unique Values SELECT DISTINCT NAME FROM Table GROUP BY NAME;   Counting Groups of Occurrences SELECT DISTINCT NAME, COUNT(*) FROM Table GROUP BY NAME;   Math sdf Summarize groups [...]

Comments Off on Important SQL Tricks for GIS