samedi 23 juillet 2016

SQL query - Finding the max value of an attribute without a subquery

Consider the relation Book with the following simple schema

Book(title, pages)

I want to find the title(s) of the book(s) with the highest number of pages, but without using a subquery.

Is this possible?

EDIT: This is not for a particular DBMS. I'm studying from a book (which uses the SQL-99 Standard) and this is a part from an exercise.

Aucun commentaire:

Enregistrer un commentaire