You must sign in to ask a question. If you do not have an account, you can register here

How to use "WITH" clause query using temporary tables to create a view in DENODO
answered 23-02-2017 11:58:26 -0500

I am trying to create a view using the query which is having WITH clause for temporary table but getting syntax error.. please help me asap. ex: WITH dept_count AS ( SELECT deptno, COUNT(*) AS dept_count,ROW_NUMBER() OVER(PARTITION BYdeptno ORDER BY...

Answers: 3

view WITH