Relational Algebra - Maximum Value in SQL

Question

It says everywhere that I suppose to use this in a query https://stackoverflow.com/a/5333881/5666540

SELECT Course.Name FROM Course
    MINUS
SELECT Course.Name FROM Course, Course as Course_1 WHERE Course.Name<Course_1.Name;

But my SQL Developer says that there is a mistake in "as", how can I rename that table ... I mean create a temporary one.

Answer 1

Oracle syntax does not allow AS keyword for normal tables or views. Just remove it.

SELECT Course.Name FROM Course
    MINUS
SELECT Course.Name FROM Course, Course Course_1 WHERE Course.Name < Course_1.Name;