Forum Discussion

ArtieLadie's avatar
ArtieLadie
Regular Visitor
7 years ago

Oracle SQL CTE not working - any workarounds???

I've been working on a query for nearly a month   I import Oracle SQL into PowerBI, and I wish for distinct columns   SELECT TO_CHAR(MIN(I.INCIDENTID)) AS "Incident ID", ...
Need Help
ArtieLadie's avatar
ArtieLadie
Regular Visitor
7 years ago

Thank you for your response --- however I still need assistance

 

I already made sure

1. Syntax is correct.

2. FROM is in correct place, and no spelling errors have occurred.

3. No reserved words were used as an alias

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi ArtieLadie ,

     

    Maybe you need to check it again , for example the bracket ")" in a wrong place, or you may ask someone great who is good at it.

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy