有关"order by" 用法

来源：学生作业帮编辑：神马作文网作业帮分类：英语作业时间：2024/10/02 14:35:09

有关"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'

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
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') a
order by a.title asc

有关"order by" 用法关于order by 的用法 group by order by mysql中的select语句where条件group by ,having ,order by,limit的顺序及用法 order用法的问题? order 的用法 order的用法有关trial order, order by 和 group by 的区别? in order to得用法 in order that的用法 in order to ,in order,in the order 和in order that的区别和用法