SELECT SUM(ADD012011) / 1000 AS ADD012011, SUM(ADD022011) / 1000 AS ADD022011, SUM(ADD032011)
/ 1000 AS ADD032011, SUM(ADD042011) / 1000 AS ADD042011, SUM(ADD052011) / 1000 AS ADD052011,
SUM(ADD062011) / 1000 AS ADD062011
FROM dbo.qry_investtracking我想连着ID一块查出来 但是貌似要包含在聚合函数中,我该怎么给这个结果视图建立一个ID啊?
/ 1000 AS ADD032011, SUM(ADD042011) / 1000 AS ADD042011, SUM(ADD052011) / 1000 AS ADD052011,
SUM(ADD062011) / 1000 AS ADD062011
FROM dbo.qry_investtracking我想连着ID一块查出来 但是貌似要包含在聚合函数中,我该怎么给这个结果视图建立一个ID啊?
解决方案 »
- _RecordsetPtr的open函数不能执行哪些SQL语句?
- backup database 123问题
- 如何将多行数据合并成一行多列,并将结果生成视图
- 我想保存修改以前的记录,以便以后查询,不知方法如何处理。
- provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接
- 找公交查询SQL语句(最快的方法)
- 急:安装完sqlserver后,返回所有行时出错
- 如何实现某列和identity列相同的内容呢?
- 小弟求教———怎样找到网络中已有的sql服务?甩分了!
- 如何update某列为具有相同项的结果。
- mysql 外键约束的问题
- 【求助】dbf导入到sql的一个问题
SUM(ADD012011) / 1000 AS ADD012011, SUM(ADD022011) / 1000 AS ADD022011, SUM(ADD032011)
/ 1000 AS ADD032011, SUM(ADD042011) / 1000 AS ADD042011, SUM(ADD052011) / 1000 AS ADD052011,
SUM(ADD062011) / 1000 AS ADD062011
FROM dbo.qry_investtracking
报这个错..
/ 1000 AS ADD032011, SUM(ADD042011) / 1000 AS ADD042011, SUM(ADD052011) / 1000 AS ADD052011,
SUM(ADD062011) / 1000 AS ADD062011
,ID = 1
FROM dbo.qry_investtracking
/ 1000 AS ADD032011, SUM(ADD042011) / 1000 AS ADD042011, SUM(ADD052011) / 1000 AS ADD052011,
SUM(ADD062011) / 1000 AS ADD062011
,ID = max(id)
FROM dbo.qry_investtracking
一行数据加个ID有什么意义?
SELECT
SUM(ADD012011) / 1000 AS ADD012011, SUM(ADD022011) / 1000 AS ADD022011, SUM(ADD032011)
/ 1000 AS ADD032011, SUM(ADD042011) / 1000 AS ADD042011, SUM(ADD052011) / 1000 AS ADD052011,
SUM(ADD062011) / 1000 AS ADD062011, SUM(BudgetAD012011) / 1000 AS BudgetADD012011, SUM(BudgetADD022011)
/ 1000 AS BudgetADD022011, SUM(BudgetADD032011) / 1000 AS BudgetADD032011, SUM(BudgetADD042011)
/ 1000 AS BudgetADD042011, SUM(BudgetADD052011) / 1000 AS BudgetADD052011, SUM(BudgetADD062011)
/ 1000 AS BudgetADD062011, SUM(BudgetADD072011) / 1000 AS BudgetADD072011, SUM(BudgetADD082011)
/ 1000 AS BudgetADD082011, SUM(BudgetADD092011) / 1000 AS BudgetADD092011, SUM(BudgetADD102011)
/ 1000 AS BudgetADD102011, SUM(BudgetADD112011) / 1000 AS BudgetADD112011, SUM(BudgetADD122011)
/ 1000 AS BudgetADD122011
FROM dbo.qry_investtrackingGROUP BY plant