有关"order by" 用法请问如果我想在下面加上 ' order by title asc' ,应该加在哪里才能使最后结果以字母顺序表示出来?select Film.titlefrom Film,Film_Actor ,Actor where Film.film_id = Film_Actor.film_id and Film_Actor.act
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/06 13:42:04
![有关](/uploads/image/z/11094793-25-3.jpg?t=%E6%9C%89%E5%85%B3%22order+by%22+%E7%94%A8%E6%B3%95%E8%AF%B7%E9%97%AE%E5%A6%82%E6%9E%9C%E6%88%91%E6%83%B3%E5%9C%A8%E4%B8%8B%E9%9D%A2%E5%8A%A0%E4%B8%8A+%27+order+by+title+asc%27+%2C%E5%BA%94%E8%AF%A5%E5%8A%A0%E5%9C%A8%E5%93%AA%E9%87%8C%E6%89%8D%E8%83%BD%E4%BD%BF%E6%9C%80%E5%90%8E%E7%BB%93%E6%9E%9C%E4%BB%A5%E5%AD%97%E6%AF%8D%E9%A1%BA%E5%BA%8F%E8%A1%A8%E7%A4%BA%E5%87%BA%E6%9D%A5%3Fselect+Film.titlefrom+Film%2CFilm_Actor+%2CActor+where+Film.film_id+%3D+Film_Actor.film_id+and+Film_Actor.act)
有关"order by" 用法请问如果我想在下面加上 ' order by title asc' ,应该加在哪里才能使最后结果以字母顺序表示出来?select Film.titlefrom Film,Film_Actor ,Actor where Film.film_id = Film_Actor.film_id and Film_Actor.act
有关"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" 用法请问如果我想在下面加上 ' order by title asc' ,应该加在哪里才能使最后结果以字母顺序表示出来?select Film.titlefrom Film,Film_Actor ,Actor where Film.film_id = Film_Actor.film_id and Film_Actor.act
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