Nested Table Expression(NTE) is a select statement within a from clause
Example :
Select * From (Select max(salary) As MaxSalary, Dept From EmpMst E Group by Dept ) As T2
A great place to learn RPG Free, SQL, CL programming tips and techniques
Nested Table Expression(NTE) is a select statement within a from clause
Example :
Select * From (Select max(salary) As MaxSalary, Dept From EmpMst E Group by Dept ) As T2