<div>
select max(date), type<br />
from thetable<br />
group type
</div>


select max(date), type
from thetable
group type

<div>
correction...<br />
<br />
group by type
</div>


<div>
Grrr corection again...<br />
My head must still be on the pillow. I hate Monday morning :)<br />
Ignore my entire response, now that I look at it properly it only returns 1 row.<br />
Sorry :(
</div>


Grrr corection again...
My head must still be on the pillow. I hate Monday morning :)
Ignore my entire response, now that I look at it properly it only returns 1 row.
Sorry :(

<div>
Thanks opho. These queries are hard for me sometimes I get stuck on them and rely on my experts-exchange friends.
</div>


Thanks opho. These queries are hard for me sometimes I get stuck on them and rely on my experts-exchange friends.

<div>
cool, MacNuttin...<br />
<br />
I hear ya!
</div>


<div>
<div class="content wysiwyg-content">
I have one table with dated records of 4 different types by employee. I need to query the newest record of each type by employee<br />
<br />
Example:<br />
emp &nbsp; &nbsp;type &nbsp;result &nbsp;date<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; -1 &nbsp; &nbsp; &nbsp; &nbsp;03/03/07<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03/03/06<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; 03/03/05<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; 03/01/07<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4 &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; 03/03/07<br />
<br />
I need:<br />
emp &nbsp; &nbsp;type &nbsp;result &nbsp;date<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; -1 &nbsp; &nbsp; &nbsp; &nbsp;03/03/07<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; 03/03/05<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; 03/01/07<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4 &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; 03/03/07
</div>
</div>


I have one table with dated records of 4 different types by employee. I need to query the newest record of each type by employee

Example:
emp    type  result  date
1           1       -1        03/03/07
1           1       0          03/03/06
1           2        0         03/03/05
1           3        1         03/01/07
1           4        0         03/03/07

I need:
emp    type  result  date
1           1       -1        03/03/07
1           2        0         03/03/05
1           3        1         03/01/07
1           4        0         03/03/07

Get the newest records of each type

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.