comment on

There are several ways to do it, depending on your database. The most portable is:

SELECT t.jobname
  , t.status
  , t.timestamp
  , t.comment
FROM your_table t
  JOIN (
      SELECT jobname, MAX(timestamp) as timestamp
      FROM your_table
      GROUP BY jobname
    ) max_timestamp
    ON max_timestamp.jobname = t.jobname
      AND max_timestamp.timestamp = t.timestamp
[download]

Of course this assumes that you don't have 2 entries with the same name and the same timestamp. It is usually less efficient than selecting back and filtering outside of the database.

Google tells me that Sybase doesn't yet support the better SQL 2003 solution of analytic queries.

Also a note about your solution. I would strongly recommend ordering on jobname and then timestamp. This will put all of the records for each jobname together, making it easy to figure out which is first and which you should throw. Otherwise you need to keep a potentially large hash of which jobs you've seen. (You skipped that step in your code.)

In reply to Re^2: Help with removing dupes from a string with perl by tilly
in thread Help with removing dupes from a string with perl by CG_man

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


go ahead... be a heretic
	PerlMonks