<div>
Melih, you are the man. Thanks a lot.<br />
<br />
Jeffrey Zheng
</div>


Melih, you are the man. Thanks a lot.

Jeffrey Zheng

<div>
<div class="content wysiwyg-content">
I have a log table like this:<br />
<br />
username productID purchasetime<br />
--------------------------<wbr />----------<wbr />----------<wbr />-----<br />
user1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/02/1999<br />
user1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03/05/2000<br />
user2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02/03/2000<br />
user2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;31 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02/04/2000<br />
user2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02/04/2000<br />
....<br />
<br />
I want to select users that purchased product later than a predefined time, say 01/01/1998, but if a user purchase a same product at different dates, then only the latest one will be selected. How to write the query? Thanks a lot.
</div>
</div>


I have a log table like this:

username productID purchasetime
---------------------------------------------------
user1          12           01/02/1999
user1          12           03/05/2000
user2          23           02/03/2000
user2          31           02/04/2000
user2          23           02/04/2000
....

I want to select users that purchased product later than a predefined time, say 01/01/1998, but if a user purchase a same product at different dates, then only the latest one will be selected. How to write the query? Thanks a lot.

select latest records based on datetime

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.