<div>
try this?<br />
<br />

<pre><code id="code-8227514">select A,B,C,D,E from table1

inner join 
(
select A,B,C, Max(D) as MAXD from table1
group by A,B,C
) maxvalue

where table1.A = maxvalue.A
and table1.B = maxvalue.B
and table1.C = maxvalue.C
and table1.D = maxvalue.MAXD</code></pre>
</div>


try this?



select A,B,C,D,E from table1

inner join 
(
select A,B,C, Max(D) as MAXD from table1
group by A,B,C
) maxvalue

where table1.A = maxvalue.A
and table1.B = maxvalue.B
and table1.C = maxvalue.C
and table1.D = maxvalue.MAXD

<div>
Code below - syntax error at WHERE that occurs after the MaxValue - error message is: Incorrect syntax near the keyword 'WHERE'<br />

<pre><code id="code-8227515">(SELECT wr.Priority FROM AQD.qaoc_Work_Request wr INNER JOIN (SELECT WR_Period, WR_Type, WR_Number, MAX(Target_Start_Date) as Maxp FROM AQD.qaoc_Work_Request GROUP BY WR_Period, WR_Type, WR_Number) MaxValue
						WHERE wr.WR_Period = MaxValue.WR_Period AND wr.WR_Type = MaxValue.WR_Type AND wr.WR_Number = MaxValue.WR_Number and wr.Target_Start_Date =  MaxValue.Maxp)</code></pre>
</div>


Code below - syntax error at WHERE that occurs after the MaxValue - error message is: Incorrect syntax near the keyword 'WHERE'


(SELECT wr.Priority FROM AQD.qaoc_Work_Request wr INNER JOIN (SELECT WR_Period, WR_Type, WR_Number, MAX(Target_Start_Date) as Maxp FROM AQD.qaoc_Work_Request GROUP BY WR_Period, WR_Type, WR_Number) MaxValue
						WHERE wr.WR_Period = MaxValue.WR_Period AND wr.WR_Type = MaxValue.WR_Type AND wr.WR_Number = MaxValue.WR_Number and wr.Target_Start_Date =  MaxValue.Maxp)

<div>
Awesome - thanks for the prompt help
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts, I have a table - columns A,B,C are the primary key, column D is a date, and E is a varchar.<br />
<br />
What I need is for eack PK, I want the data for column E returned for the latest date - leaving behing all earlier records for each PK. Try as I might, I just can't see it - been coding too long today.<br />
<br />
Kelvin
</div>
</div>


Hi Experts, I have a table - columns A,B,C are the primary key, column D is a date, and E is a varchar.

What I need is for eack PK, I want the data for column E returned for the latest date - leaving behing all earlier records for each PK. Try as I might, I just can't see it - been coding too long today.

Kelvin

Return latest value

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.