AnsweredAssumed Answered

How to run  a seql statement: select field1, field2, field3 from table

Question asked by jsn on Mar 23, 2018
Latest reply on Mar 27, 2018 by jsn

Hello everyone,

 

What object do I need to run a this SQL statement in a ArcGIS Geo-processing object using Python  or Visual studio.

 

Dim dsde3Query As String =

SELECT CONTENTID, COUNT(CONTENTID) AS Counter " _

& "FROM ([owner].[table]) " _

& "GROUP BY CONTENTID " _

& "HAVING(COUNT(CONTENTID) > 1) " _

& "ORDER BY Counter DESC "

 

 

 

 

 

Thanks

 

Outcomes