皮皮学，免费搜题
登录
logo - 刷刷题
搜题
【简答题】
已知教师表( js )含有工号( gh , C )、姓名( xm , C )等字段,图书借阅表( jyb )含有读者号( dzh , C )、分类号( flh , C )、借阅日期( jyrq , D )、还书日期( hsrq , D )等字段,教师的读者号与工号相同, 完成下列 SELECT-SQL 语句,基于 js 表和 jyb 查询教师借书情况,计算过期罚款信息(罚款计算方法为 30 天以上超过部分每本每天 0.01 元, 30 天以内罚款为 0 ,未还书者(即还书日期为空的记录)不统计),查询结果按罚款额降序排序,输出去向为文本文件 temp 。 Select dzh,xm, AS 罚款额 ; Form js Inner Join jyb; On js.gh=jyb.dzh; Where ; ; Order by 3 desc; temp
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
微信内点击右上角“…”即可分享
反馈
参考答案：
举一反三
【单选题】I was just going to cut my rose bushes but someone _____ it. Was it you? [     ]
A.
has done
B.
had done
C.
would do
D.
will do
查看完整题目与答案
【单选题】Most of the work was done by my sister and _______. [     ]
A.
me
B.
I
C.
my
D.
Mine
查看完整题目与答案
【单选题】I was just going to water my garden but someone _____ it. Was it Tom? [     ]
A.
has done
B.
had done
C.
would do
D.
was doing
查看完整题目与答案
【简答题】Most of the work was done by my sister and me B. I C. my D. Mine
查看完整题目与答案
【单选题】一圆形线圈，它的一半处于均匀磁场中，另一半位于磁场之外，如图所示。磁感应强度B的方向垂直地指向纸面内。欲使圆线圈中感应出顺时针方向的电流，则( )【图片】
A.
线圈应沿X 轴正向平动
B.
线圈应沿Y 轴正向平动
C.
线圈应沿Y 轴负向平动
D.
线圈应沿X 轴负向平动
查看完整题目与答案
【判断题】Excel工作簿的第一个工作表都有一个默认的名字Sheet1 ()。
A.
正确
B.
错误
查看完整题目与答案
【单选题】Excel 2010工作簿的第一个工作表都有一个默认的名字,它是( )。
A.
Book1
B.
Sheet1
C.
Excel 20101
D.
Word1
查看完整题目与答案
【单选题】近端小管对钠离子重吸收量经常是Na+的滤过量的
A.
45--50%
B.
55--65%
C.
65--70%
D.
75--80%
E.
98--99%
查看完整题目与答案
【单选题】The experiment, ________ will soon be announced~ was done by my colleagues.
A.
whose results
B.
the results on which
C.
at which the results
D.
of whose results
查看完整题目与答案
【单选题】My parents died young, but I have done well in this respect ________ my other ancestors.
A.
to
B.
for
C.
as regards
D.
with
查看完整题目与答案
相关题目：
【单选题】I was just going to cut my rose bushes but someone _____ it. Was it you? [     ]
A.
has done
B.
had done
C.
would do
D.
will do
查看完整题目与答案
【单选题】Most of the work was done by my sister and _______. [     ]
A.
me
B.
I
C.
my
D.
Mine
查看完整题目与答案
【单选题】I was just going to water my garden but someone _____ it. Was it Tom? [     ]
A.
has done
B.
had done
C.
would do
D.
was doing
查看完整题目与答案
【简答题】Most of the work was done by my sister and me B. I C. my D. Mine
查看完整题目与答案
【单选题】一圆形线圈，它的一半处于均匀磁场中，另一半位于磁场之外，如图所示。磁感应强度B的方向垂直地指向纸面内。欲使圆线圈中感应出顺时针方向的电流，则( )【图片】
A.
线圈应沿X 轴正向平动
B.
线圈应沿Y 轴正向平动
C.
线圈应沿Y 轴负向平动
D.
线圈应沿X 轴负向平动
查看完整题目与答案
【判断题】Excel工作簿的第一个工作表都有一个默认的名字Sheet1 ()。
A.
正确
B.
错误
查看完整题目与答案
【单选题】Excel 2010工作簿的第一个工作表都有一个默认的名字,它是( )。
A.
Book1
B.
Sheet1
C.
Excel 20101
D.
Word1
查看完整题目与答案
【单选题】近端小管对钠离子重吸收量经常是Na+的滤过量的
A.
45--50%
B.
55--65%
C.
65--70%
D.
75--80%
E.
98--99%
查看完整题目与答案
【单选题】The experiment, ________ will soon be announced~ was done by my colleagues.
A.
whose results
B.
the results on which
C.
at which the results
D.
of whose results
查看完整题目与答案
【单选题】My parents died young, but I have done well in this respect ________ my other ancestors.
A.
to
B.
for
C.
as regards
D.
with
查看完整题目与答案
参考解析：
知识点：
题目纠错 0
发布
创建自己的小题库 - 刷刷题