algorithm
algorithm copied to clipboard
RUNTIME ERROR !! - Article Views I
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select distinct author_id as id from Views where author_id = viewer_id order by ' at line 13
The solution worked for me ...!!
SELECT DISTINCT author_id AS id FROM Views WHERE author_id = viewer_id ORDER BY author_id ASC;