Distinct Query On One Column

While this query has more than what may be needed this will help you to get data based on one unique column.

SELECT [File Name]
	,[Division]
	,[Version]
FROM (
	SELECT [File Name]
		,[Division]
		,[Version]
		,row_number() OVER (
			PARTITION BY [Division] ORDER BY [Version] DESC
			) AS RowNumber
	FROM <DatabaseTableName>
	) AS A
WHERE a.RowNumber = 1
	AND (
		[Version] LIKE '%2014%'
		OR [Version] LIKE '%2013%'
		)