General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
it did not work
SELECT UPPER(au_lname) AS au_lname ;
FROM authors ;
GROUP BY au_lname ;
HAVING COUNT(*) > 1 ;
INTO CURSOR firstpass_cursor
SELECT authors.* ;
FROM firstpass_cursor, authors ;
WHERE UPPER(authors.au_lname) = firstpass_cursor.au_lname ;
INTO CURSOR secondpass_cursor ;
ORDER BY firstpass_cursor.au_lname
ERRORS ARE
Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'FROM'.
Server: Msg 156, Level 15, State 1, Line 8
Incorrect syntax near the keyword 'FROM'.
Thanks Mohammed
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only