ShawnMolloy
MIS
Why does this query return an error saying:
"Invalid column name 'rowNum'."
Shawn Molloy
Seattle, WA
"Invalid column name 'rowNum'."
Code:
SELECT
ROW_NUMBER() OVER (ORDER BY userid) as rowNum,
userid,
dateadded
FROM
Wisetopic_Friend
WHERE
rowNum > 3
Shawn Molloy
Seattle, WA