题目

有关"order by" 用法
请问如果我想在下面加上 ' order by title asc' ,应该加在哪里才能使最后结果以字母顺序表示出来?
select Film.title
from Film,Film_Actor ,Actor
where Film.film_id = Film_Actor.film_id and
Film_Actor.actor_id = Actor.actor_id and
Actor.first_name ='q' and Actor.last_name= 'a'
minus
select Film.title
from Film,Film_Actor ,Actor
where Film.film_id = Film_Actor.film_id and
Film_Actor.actor_id = Actor.actor_id and
Actor.first_name ='P' and Actor.last_name= 'o'

提问时间：2021-01-21

答案

select a.* from (select Film.title from Film,Film_Actor ,Actor where Film.film_id = Film_Actor.film_id and Film_Actor.actor_id = Actor.actor_id and Actor.first_name ='q' and Actor.last_name= 'a' minus...