<div>
If you need user_description or extradata on your select use a subquery<br />
like...hope it help you<br />
&nbsp;<br />
<br />

<pre><code id="code-191780">SELECT *
FROM user_logon 
WHERE EXISTS ( 
	SELECT 1 FROM
		 (select user, max(user_login_time) Last_login_time
                   from user_logon
                   group by user)  T
      WHERE user_logon.user = T.user 
	    AND Last_login_time=user_logon .user_login_time  
)</code></pre>
</div>


If you need user_description or extradata on your select use a subquery
like...hope it help you
 



SELECT *
FROM user_logon 
WHERE EXISTS ( 
	SELECT 1 FROM
		 (select user, max(user_login_time) Last_login_time
                   from user_logon
                   group by user)  T
      WHERE user_logon.user = T.user 
	    AND Last_login_time=user_logon .user_login_time  
)

<div>
<div class="content wysiwyg-content">
I have a table that logs user logons called user_logon, with fields id, user and user_login_time.<br />
<br />
id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; user_description &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user_login_time<br />
1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user_a &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user a &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10-10-2008 10:23<br />
2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user_a &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user a &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10-10-2008 11:25<br />
3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user_a &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user a &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11-10-2008 10:00<br />
4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user_b &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user b &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10-10-2008 10:23<br />
5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user_b &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user b &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10-10-2008 10:25<br />
6 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user_b &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user b &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12-10-2008 10:00<br />
<br />
I wish to select the last time that each user has logged on. How do I do this? 
</div>
</div>


I have a table that logs user logons called user_logon, with fields id, user and user_login_time.

id	user	        user_description	user_login_time
1	user_a	user a			10-10-2008 10:23
2	user_a	user a			10-10-2008 11:25
3	user_a	user a			11-10-2008 10:00
4	user_b	user b			10-10-2008 10:23
5	user_b	user b			10-10-2008 10:25
6	user_b	user b			12-10-2008 10:00

I wish to select the last time that each user has logged on. How do I do this? 

SQL last user login date

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.