[EMAIL PROTECTED] wrote:
Hi!
I have a problem that may only be solvable using a programming approach, but
I'm wondering if there is an SQL method in MySQL.
The problem is that I have a table that looks like this:
CREATE TABLE `test` ( `uid` mediumint(6) NOT NULL auto_increment,
On Sat, 20 Nov 2004 19:14:55 -0800
<[EMAIL PROTECTED]> wrote:
> they have the same perid, program and startdate. I would very much like
> to get a listing for each perid that shows their perid, program, startdate
> and then the latest (only the latest) stopdate. This would give unique
SELECT pe
Hi!
I have a problem that may only be solvable using a programming approach, but
I'm wondering if there is an SQL method in MySQL.
The problem is that I have a table that looks like this:
CREATE TABLE `test` ( `uid` mediumint(6) NOT NULL auto_increment,
`perid` varchar(10) default NULL, `pro
