Ingres Database - CTE query is not working

47 Views Asked by At

I am trying to implement a CTE in Ingres Databaseas below

 with sample_cte(email) as(
     select distinct email_address as email from table1)
 select email from sample_cte;

But i am getting below Error when executing this query.Can anyone please help

Error : Query or Procedure returns a result set
SQLState: 21000
ErrorCode :802840

Can anyone help on this

0

There are 0 best solutions below