topic Re: Select query addition in Application Development and Automation Discussions

Select query addition

Former Member — Tue, 23 Mar 2010 17:03:25 GMT

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 — Tue, 23 Mar 2010 17:12:47 GMT

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 — Tue, 23 Mar 2010 18:40:01 GMT

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