Here is i am trying to execute the below query in teradata using level but it giving me error. Please help me to resolve this issue.
SELECT LEVEL,MIN(SAL) FROM EMP
WHERE LEVEL = 2
CONNECT BY PRIOR SAL < SAL
GROUP BY LEVEL
Solved! Go to Solution.
I'm not sure what you are trying to do, but Teradata (and DB2, and ANSI Standard SQL) use recursive Common Table Expressions (CTEs) instead of Connect-By, which is Oracle-specific syntax. For details and examples, go to
Then click Select, the WITH Statement Modifier. Or just go to info.teradata.com and download the SQL DML manual.