Distinct Query On One Column

Posted on By David Kittell

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%'
		)
Originally Posted on May 20, 2014
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL

Related Posts

Web Crawler – C#

Posted on

<?xml version="1.0"?> <configuration> <configSections> <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" > <section name="WebCrawler.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" /> </sectionGroup> </configSections> <startup> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/> </startup> <userSettings> <WebCrawler.Properties.Settings> <setting name="LogPath" serializeAs="String"> <value>C:tempWebCrawlerErrorLog.txt</value> </setting> <setting name="XMLPath" serializeAs="String"> <value>C:tempWebCrawlerWebCrawlerLog.xml</value> </setting> <setting name="URLPath" serializeAs="String"> <value /> </setting> <setting name="TrimTitle" serializeAs="String">…

Read More

Filter Datagrid

Posted on

If you already have a data grid and want to search it you can create a textbox and do a textbox.textchanged control to run something like below: YourGridViewBindingSource.Filter = String.Format("YourDBColumn Like ;’*" & FilterValue) & "*’" Originally Posted on March 1, 2013Last Updated on October 26, 2015 All information on…

Read More

Ektron Find Replace In UrlAliasManual

Posted on

This script will rename manual aliases set xact_abort on declare @currval nvarchar(500) declare @newval nvarchar(500) declare @search nvarchar(500) declare @replace varchar(500) set @search = ‘/Index’ –string to find set @replace = ‘/Default’ –replacement string declare @pos int declare @id bigint begin tran declare curs cursor local fast_forward for select AliasId,AliasName…

Read More