<div>
If you're trying to just get the rows that have the max date for each code, you might want to try:<br />
<br />
select code, name, date from table a<br />
where date=(select max(date) from table b<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; where a.code = b.code)<br />
<br />
BTW, that's not a typo. &nbsp;It's a double reference to the same table.<br />
<br />
Let us know if you're looking for something else. &nbsp; :)<br />

</div>


If you're trying to just get the rows that have the max date for each code, you might want to try:

select code, name, date from table a
where date=(select max(date) from table b
           where a.code = b.code)

BTW, that's not a typo.  It's a double reference to the same table.

Let us know if you're looking for something else.   :)


<div>
Thanx Mayhew<br />
Your comment solved my probelm.<br />

</div>


Thanx Mayhew
Your comment solved my probelm.


<div>
Glad to be of service.<br />
<br />
BTW, if you want to award points to a comment, you can reject a previous answer and ask the comment poster to repost as an answer. &nbsp;That way you can award points to the person that helped you.<br />
<br />
Just wanted to let you know. &nbsp;:)<br />
<br />
Again, I'm glad it's working for you.<br />

</div>


Glad to be of service.

BTW, if you want to award points to a comment, you can reject a previous answer and ask the comment poster to repost as an answer.  That way you can award points to the person that helped you.

Just wanted to let you know.  :)

Again, I'm glad it's working for you.


<div>
<div class="content wysiwyg-content">
I have the Data:<br />
<br />
code &nbsp; name &nbsp; &nbsp; date<br />
.........................<br />
code1 &nbsp;namea &nbsp; &nbsp;date1<br />
code1 &nbsp;nameb &nbsp; &nbsp;date2<br />
code1 &nbsp;namec &nbsp; &nbsp;date3<br />
code2 &nbsp;namem &nbsp; &nbsp;datex<br />
code2 &nbsp;namen &nbsp; &nbsp;datey<br />
code2 &nbsp;nameo &nbsp; &nbsp;datez<br />
<br />
so on.........<br />
I want result as<br />
<br />
code1 &nbsp; name &nbsp;max(date)<br />
code2 &nbsp; name &nbsp;max(date)<br />
<br />
<br />
I want the details of each code,..... when Date is Max.<br />
<br />
I have tried Group By with Having.<br />
Anybody with sample code/syntax<br />
<br />
Thanx<br />

</div>
</div>


I have the Data:

code   name     date
.........................
code1  namea    date1
code1  nameb    date2
code1  namec    date3
code2  namem    datex
code2  namen    datey
code2  nameo    datez

so on.........
I want result as

code1   name  max(date)
code2   name  max(date)


I want the details of each code,..... when Date is Max.

I have tried Group By with Having.
Anybody with sample code/syntax

Thanx


Group By....Having

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.