Re: [SQL] help with limiting query results

"OizOne" <[EMAIL PROTECTED]> writes: > I would need to create a query that selects each hostname only once with > username that has the latest timestamp in the logontime column. SELECT DISTINCT ON is a convenient way to do this. See the "weather reports" example in the SELECT reference page for a

[SQL] help with limiting query results

Hi, I have the following table in postgres: hostname | username| logontime --+---+ ws1 | rautaonn | 2004-01-13 21:25:01.100336 ws1 | administrator | 2004-01-13 21:25:07.706546 ws1 | testuser | 2004