<div>
<div class="content wysiwyg-content">
I have a table where In need to find the last transaction of a unique ID 
Eg 
 
SalesID &nbsp; &nbsp; TransID &nbsp; &nbsp; &nbsp;Name &nbsp; 
&nbsp; &nbsp;85 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;197 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;xxxx 
&nbsp; &nbsp;85 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 199 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;xxxx 
&nbsp; &nbsp; 85 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;285 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;xxxxxxxxxx 
&nbsp; &nbsp; 85 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 167 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;xxxx 
&nbsp; &nbsp;106 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 298 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;xxxx 
&nbsp; &nbsp;106 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 402 &nbsp; &nbsp; &nbsp; &nbsp;xxxxxxxxxx 
&nbsp; &nbsp;106 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 588 &nbsp; &nbsp; &nbsp; &nbsp; xxxx 
 
 
so the above I would want to return the max unique ID(TransID) &nbsp;- &nbsp;in the above case the highest TransID of each unique SalesID 
 
 
Resuts Id wanted returned from the above. 
 
SalesID &nbsp; &nbsp; TransID &nbsp; &nbsp; &nbsp;Name &nbsp; 
&nbsp;85 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;285 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;xxxxxxxxxx 
106 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 588 &nbsp; &nbsp; &nbsp; &nbsp; xxxx 
 
 
&nbsp; &nbsp; 
</div>
</div>

I have a table where In need to find the last transaction of a unique ID
Eg

SalesID     TransID      Name  
   85              197            xxxx
   85               199            xxxx
    85              285            xxxxxxxxxx
    85               167            xxxx
   106               298            xxxx
   106               402        xxxxxxxxxx
   106               588         xxxx


so the above I would want to return the max unique ID(TransID)  -  in the above case the highest TransID of each unique SalesID


Resuts Id wanted returned from the above.

SalesID     TransID      Name  
 85              285            xxxxxxxxxx
106               588         xxxx


    

Find Max unique  ID SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.