[GIS] Using sql SELECT DISTINCT in Fusion Tables API

Question

How do I go about using sql SELECT DISTINCT in fusion tables API?

Answer 1

While you can't use SELECT DISTINCT, you can use a GROUP BY to solve some of the same problems as DISTINCT:

SELECT DISTINCT name, address from TABLEID

and

SELECT name, address from TABLEID group by name, address

should yield the same results. Fusion Tables SQL is quirky though so you may need to throw a "count()" into your SELECT statement.

(Yes, old thread.)