Re: Illegal Character in max(id) with Execute SQL Processor

[rakesh]

Hi Mark,


Thanks for your help, it is working now.

*select max(id) AS mxId from ${dbname}.records where sid=${siteId}*
*select id from ${dbname}.records where id=${Id} order by id desc limit 1;*
Both are working.



Thanks
Rakesh.



--
Sent from: http://apache-nifi-users-list.2361937.n4.nabble.com/