Thank you Mike Bayer for your help..
On Wednesday, June 27, 2018 at 8:32:18 PM UTC+5:30, Mike Bayer wrote:
>
> On Wed, Jun 27, 2018 at 3:22 AM, arjun k >
> wrote:
> > Hi
> > i was trying to convert the below query to sqlalchemy
> >
> >
> > SE
Hi
i was trying to convert the below query to sqlalchemy
SELECT
addr_idn,
(SELECT MAX(LastUpdateDate)
FROM (VALUES (crt_dt),(upd_dt),) AS UpdateDate(LastUpdateDate))
AS LastUpdateDate
FROM (
select a. addr_idn,a.crt_dt crt_dt , b.upd_dt upd_dt
from emp_addr
where