Select records where date = maxdate

gopskrish · Post by **gopskrish** » Tue May 10, 2005 9:30 am

Hi Guys,

I am using Sybase as the source and i would like to retrieve records where <date> = max(date) in the database.

How can i get that ?

Can anyone help me on this.

source sybase
job Parallel
tgt sequential

cheers,
gops

Sunshine2323 · Post by **Sunshine2323** » Tue May 10, 2005 9:48 am

Hi,

You can get your date in this format YYYYMMDD and then pass the data through an Aggregator to find the max date.

ogmios · Post by **ogmios** » Tue May 10, 2005 9:53 am

How about:

Code: Select all

select columns, ...
from table
where date = ( select max(date) from table )

in Sybase... the biggest disadvantage of calculating the maximum in DataStage is that you have the I/O from Sybase to DataStage (where depending on your input a lot of data is not useful).

Ogmios