Posted by Plamen Ratchev on 01/08/08 03:40

Here is one way to get you the results:

SELECT Schedule_Number,
Process_Description,
MAX(TMDT) AS TMDT
FROM Process_Data
WHERE Process_Description = 'Exit Cold Rinse'
AND Schedule_Number LIKE '12345%'
GROUP BY Schedule_Number, Process_Description

Really no need for joins and the logic for Schedule_Number is converted to
utilize any index on the column.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: DB2 Tutorial
• Prev in forum: Re: FOR XML EXPLICIT can't get element 4 going
• Thread view: Re: Select Max values from queries for multiple Schedule_Number

[Reply to this message]