CODEWITHSUNDEEP
sqldatabaseetlingresactian
vmb
vmb

Reputation: 3028

Ingres Database - CTE query is not working

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

Upvotes: 0

Views: 63

Answers (0)

Related Questions