This content has been marked as final. Show 7 replies
I will make some SQL experts cringe with this question, sorry ; I am self-taught and a rookie in QV and SQL.
So, I want to thank everybody in advance for the help.
I learned recently the use of QV's preceding loads. I need to do something similar to a QV's preceding load in a SQL query but I can't get my head around it.
This is the query I'm trying to do (code and image). Basically I'm trying to do the total count of records of a select grouped of records, but it marks me the following error in the Teradata SQL Assistant (image 2):
from (select Producto_ID, count(Producto_ID)
group by Producto_ID