Tags: SQL
select SalesId, logdate , JSON_VALUE([Data], '$.CreatedDate') as CDate from #tmp where SalesId = 123 and Data > '' order by logdate desc