Hi
I want to insert duplicate row count in counter coulmn of same table. I had coded this but i get alias issue (illegal usage of Alias)here.
here is my query
UPDATE tablea C
FROM
(
SELECT col1,
Col2,
COUNT(col1 || Col2)
AS...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.