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

Bash – Mass NSlookup

Posted on

When you are moving from one server public IP to another you could use some help knowing things are changed. This bash script will do an NSLookup on various DNS servers. #!/bin/sh # Digkittell.net.sh # # # Created by David Kittell on 1/6/18. # netDomain="kittell.net" dnsServerList="68.94.156.132|10.40.20.1|8.8.8.8|192.168.10.21|192.168.10.20|10.40.20.6|208.67.220.220|9.9.9.9|209.18.47.61|4.2.2.2|168.63.129.16|172.26.38.1" clear echo "AT&T DNS…

Read More

Export To Excel

Posted on

Add GridView, Datasource, and Button <%@ Page Language="C#" AutoEventWireup="true" CodeFile="exporttest.aspx.cs" EnableEventValidation="false" Inherits="ExportTest" %> <form id="form1" runat="server"> <asp:gridview runat="server" id="gvExport" allowpaging="True" autogeneratecolumns="False" datakeynames="id" datasourceid="dsExport"> </asp:gridview> <asp:sqldatasource id="dsExport" runat="server" conflictdetection="CompareAllValues" connectionstring="<%$ ConnectionStrings:DbConnection %>" selectcommand="SELECT top 100 * FROM Users"> </asp:sqldatasource> <asp:button id="btnExport" runat="server" onclick="Button1_Click" text="Export To Excel" /> </form> using System; using…

Read More