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
Select records where date = maxdate
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 130
- Joined: Mon Sep 06, 2004 3:05 am
- Location: Dubai,UAE
How about:
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
Code: Select all
select columns, ...
from table
where date = ( select max(date) from table )
Ogmios
In theory there's no difference between theory and practice. In practice there is.