UC知道SQL语句分析—急～给加分
来源：百度知道 编辑：UC知道 时间：2024/05/27 04:37:20
3、use pubs
select stor_id,t.title_id,qty,ytd_sales,'ytd_sales*10%'=ytd_sales*0.1
from sales as a
inner join
titles as t
on qty>ytd_sales*0.1
where a.title_id=t.title_id
4、use pubs
select distinct t1.title_id,RTRIM(a.au_fname)+''+RTRIM(a.au_lname) author
from authors a,titleauthor t1
inner join titleauthor t2
on t1.title_id=t2.title_id
where t1.au_id<>t2.au_id and t1.au_id=a.au_id
5、use pubs
select au_id,RTRIM(a.au_fname)+'' ''+RTRIM(a.au_lname) author,p.pub_name publisher
from authors as a,publishers as p
where au_id like '[1-5]%'
order by au_id
能否在详细点
select stor_id,t.title_id,qty,ytd_sales,'ytd_sales*10%'=ytd_sales*0.1
from sales as a
inner join
titles as t
on qty>ytd_sales*0.1
where a.title_id=t.title_id
4、use pubs
select distinct t1.title_id,RTRIM(a.au_fname)+''+RTRIM(a.au_lname) author
from authors a,titleauthor t1
inner join titleauthor t2
on t1.title_id=t2.title_id
where t1.au_id<>t2.au_id and t1.au_id=a.au_id
5、use pubs
select au_id,RTRIM(a.au_fname)+'' ''+RTRIM(a.au_lname) author,p.pub_name publisher
from authors as a,publishers as p
where au_id like '[1-5]%'
order by au_id
能否在详细点
第一个两个表建立内连接条件是
第二个在表中查询出id=1到5的记录 ordery by 是按照后面的字段升序排列……
内联查询，中间做些字符串连接的操作！
不算复杂