First page Back Continue Last page Graphics
Except all, no duplicate elimination
List the name and department of borrowers who have or had more reservations than loans. (use except all)
- (select name, department
from reserve)
except all
(select name, department
from borrow)
- When someone has 5 reservations and 3 loans his name/department will appear in the answer twice.
Now try to eliminate that (without throwing out the except all clause).
Notes: