To select rows with out duplicates change the WHERE clause to "RowCnt = 1"
To select one row from each set use Rank() instead of Sum() and change the outer WHERE clause to select rows with Rank() = 1
public static GameObject Find(string name);
public static GameObject FindGameObjectWithTag(string tag);
public static GameObject[] FindGameObjectsWithTag(string tag);
public static Object FindObjectOfType(Type type);
public static Object[] FindObjectsOfType(Type type);
Which method to...
This topic is going to focus on the A* Pathfinding algorithm, how it's used, and why it works.
Note to future contributors: I have added an example for A* Pathfinding without any obstacles, on a 4x4 grid. An example with obstacles is still needed.