求知下面的 select amount from aaa m where month=1 and m.year=aaa.year 中的aaa和m是什么?year month amount1991 1 1.11991 2 1.21991 3 1.31991 4 1.41992 1 2.11992 2 2.21992 3 2.31992 4 2.4查成
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/29 15:02:58
![求知下面的 select amount from aaa m where month=1 and m.year=aaa.year 中的aaa和m是什么?year month amount1991 1 1.11991 2 1.21991 3 1.31991 4 1.41992 1 2.11992 2 2.21992 3 2.31992 4 2.4查成](/uploads/image/z/14935157-53-7.jpg?t=%E6%B1%82%E7%9F%A5%E4%B8%8B%E9%9D%A2%E7%9A%84+select+amount+from+aaa+m+where+month%3D1+and+m.year%3Daaa.year+%E4%B8%AD%E7%9A%84aaa%E5%92%8Cm%E6%98%AF%E4%BB%80%E4%B9%88%3Fyear++month+amount1991+++1+++++1.11991+++2+++++1.21991+++3+++++1.31991+++4+++++1.41992+++1+++++2.11992+++2+++++2.21992+++3+++++2.31992+++4+++++2.4%E6%9F%A5%E6%88%90)
求知下面的 select amount from aaa m where month=1 and m.year=aaa.year 中的aaa和m是什么?year month amount1991 1 1.11991 2 1.21991 3 1.31991 4 1.41992 1 2.11992 2 2.21992 3 2.31992 4 2.4查成
求知下面的 select amount from aaa m where month=1 and m.year=aaa.year 中的aaa和m是什么?
year month amount
1991 1 1.1
1991 2 1.2
1991 3 1.3
1991 4 1.4
1992 1 2.1
1992 2 2.2
1992 3 2.3
1992 4 2.4
查成这样一个结果
year m1 m2 m3 m4
1991 1.1 1.2 1.3 1.4
1992 2.1 2.2 2.3 2.4
答案一、
select year,
(select amount from aaa m where month=1 and m.year=aaa.year) as m1,
(select amount from aaa m where month=2 and m.year=aaa.year) as m2,
(select amount from aaa m where month=3 and m.year=aaa.year) as m3,
(select amount from aaa m where month=4 and m.year=aaa.year) as m4
from aaa group by year
求知下面的 select amount from aaa m where month=1 and m.year=aaa.year 中的aaa和m是什么?year month amount1991 1 1.11991 2 1.21991 3 1.31991 4 1.41992 1 2.11992 2 2.21992 3 2.31992 4 2.4查成
首先说明,如果此语句是再SQL Server中使用,必定报错.Oracle中没有这样试过,不做定论.但从语法上讲,From后面的aaa是表名,直接跟一个m只能是对表名称的转换,其类似于查询字段中常常用到的字段名称转换“Select A as B”,只不过表名称的转换时as可以省略.但是如果用了m转换表名称,则where条件里直接使用aaa.year是肯定会报错“找不到aaa”,除非查询中拿m表再和原来的aaa做一次联合查询.