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

Leave a Reply

Your email address will not be published.