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)
- with list(name, department) as
( (select name, department
from reserve)
except all
(select name, department
from borrow) )
select distinct name, department
from list
Notes: