有关"order by" 用法
有关"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'
请问如果我想在下面加上 ' 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'
英语人气:657 ℃时间:2020-02-04 10:24:28
优质解答
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...
我来回答
类似推荐
猜你喜欢
- 1把-1-[-3-(-5)-(+7)]-(+9)写成代数式和形式
- 2每隔4M种一棵树,第一颗与最后一颗相距48M,现改为每隔6M种一棵树,有几棵不用重栽
- 3次北固山下最表现思念家乡的诗句
- 4在研究压强对化学反应的限度时,对于化学方程式中气态物质系数不变的反应,增大压强,Qp仍然等于Kp,化学平衡状态不变.为什么增大压强,Qp仍然等于Kp?
- 5RL串联电路,总电压50V,电阻两端电压30V,电感两端电压多少呢
- 6某班男生32人,女生比男生少75%,女生有多少人?想:题中把()看做单位“1“的量,要求女生多少人,可以先求出()也就是()x25%=(),男生人数-()=女生人数.
- 7从下面选择合适的短语,并用其适当的形式填空,补全句子.
- 8牛郎星和织女星距地球有多远?谢喽!
- 9某校学生乘坐公交汽车到风景区春游路上共用1.5h,车在最初的半小时内行驶了15km,中间的0.5h内行驶了20Km,
- 10as well 与also的区别