CODEWITHSUNDEEP
sqloracle-databasemaxalgebrarelational
AlienTed
AlienTed

Reputation: 19

Relational Algebra - Maximum Value in SQL

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.

Upvotes: 0

Views: 99

Answers (1)

Husqvik
Husqvik

Reputation: 5809

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;

Upvotes: 2

Related Questions