in reply to Re^2: Help with removing dupes from a string with perl
in thread Help with removing dupes from a string with perl
In Sybase you can use a a group by and a having clause, even without using any aggregates in the main query.
So something like
should return something reasonable without the need for a sub-query.select jobname, status, timestamp, comment from the_table group by jobname having timestamp = max(timestamp)
Michael
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^4: Help with removing dupes from a string with perl
by tilly (Archbishop) on Jul 27, 2009 at 07:20 UTC | |
by mpeppler (Vicar) on Jul 30, 2009 at 06:02 UTC |
In Section
Seekers of Perl Wisdom