How to use CTE in another CTE

with report as (
      <your query here>
     ),
     reportLimited as (
      select *
      from report
      where foo = value
    )
select *
from reportLimited

Was this page helpful?

Yes Yes! this solution to the problem was helpful. No No! this solution to the problem was not helpful.. Leave ErnesTech Feedback.Feedback
Login to Continue

Community of Software Developers

Welcome, log in to continue reading. It's free and only takes a minute.




© 2020 - ErnesTech - Privacy