Hi,
I am new to Zoho Creator. Need help solving a simple issue. I have so far worked in SQL only, so here is what I want to achieve in Creator.
In the usual employee and department database, I need to find the name of employee in each department who gets minimum salary in his department. I would have written this in SQL to do that.

select ename,deptno, sal
from emp
where sal in (select min(sal) from emp group by deptno)

I figured there is no SQL here in Creator. Could anyone help me on how it can be done here?

Thanks in advance
Saurabh Jain