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
> >
> >
> > SELECT
> >addr_idn,
> >(SELECT
On Wed, Jun 27, 2018 at 3:22 AM, arjun k wrote:
> 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.
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