Solved: Select query addition

Former Member · ‎2010 Mar 23

Hello Group,

I want to fetch last record in the database table.

select profileid eff_date from dbtable.

as eff_date has the latest date, that has to be fetched.

Please could you advice on this.

Many Thanks,

Jagan.

SuhaSaha · ‎2010 Mar 23

Hello,

Can you not use the aggregate function MAX with the SELECT stmt ?

E.g.,

select profileid MAX( eff_date ) from dbtable.

BR,

Suhas

SuhaSaha · ‎2010 Mar 23

Hello,

Can you not use the aggregate function MAX with the SELECT stmt ?

E.g.,

select profileid MAX( eff_date ) from dbtable.

BR,

Suhas

Former Member · ‎2010 Mar 23

Thanks for your response.

I already used this, I got a workaround finally.

Many Thanks.

Edited by: jagan.sdn on Mar 23, 2010 7:40 PM

Select query addition