use hr
go
create view view_industryindicator
as
select distinct a.autoId as id,c.com_id as comid,a.year as paraYear,a.rangeId as rangeId,d.rangeName as rangeName,a.paraId as paraId,
e.superId as superId,e.paraName as paraName,b.rangeId as rangeValue,a.excellent as excellent,a.good as good,a.average as average,a.lowers as lowers,
a.worse as worse from indestryindicator a inner join industry b on a.indIndId = b.indIndId inner join company c on b.indId = c.indId inner join industryrange d on a.rangeId = d.rangeId
inner join industrypara e on a.paraId = e.paraId order by a.year desc,c.com_id,a.rangeId,a.autoId;报下面这个错,是什么原因?消息 1033,级别 15,状态 1,过程 view_industryindicator,第 6 行
除非另外还指定了 TOP 或 FOR XML,否则,ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。
go
create view view_industryindicator
as
select distinct a.autoId as id,c.com_id as comid,a.year as paraYear,a.rangeId as rangeId,d.rangeName as rangeName,a.paraId as paraId,
e.superId as superId,e.paraName as paraName,b.rangeId as rangeValue,a.excellent as excellent,a.good as good,a.average as average,a.lowers as lowers,
a.worse as worse from indestryindicator a inner join industry b on a.indIndId = b.indIndId inner join company c on b.indId = c.indId inner join industryrange d on a.rangeId = d.rangeId
inner join industrypara e on a.paraId = e.paraId order by a.year desc,c.com_id,a.rangeId,a.autoId;报下面这个错,是什么原因?消息 1033,级别 15,状态 1,过程 view_industryindicator,第 6 行
除非另外还指定了 TOP 或 FOR XML,否则,ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。
解决方案 »
- 命令行修改SQL Server 2005登陆身份为Local System,请问能实现吗?
- char和varchar的区别
- SQLSEARVER存储过程中的参数中文字符的问题
- 求教:正确的SQL 语句在SQL Server 2005 里转入视图时,报错
- 这样的插入SQL语句怎么写?
- 关于SQL Server中SQL语句的执行效率问题,请大家提供建议,来者有分!
- SQLSERVE数据库能添加数据为什么却读不出来呢?高分求救!!!
- 求一事务回滚 急急急
- 请问SQL SERVER 2000中有没有这样的功能
- 如何通过编程来更改设置sql server的帐号密码?
- SQL SERVER 关于select查询代码方面的问题
- sql查询问题 请高手速达 在线等....
DISTINCT
TOP 100 PERCENT --就需要添加top
a.autoId AS id ,
c.com_id AS comid ,
a.year AS paraYear ,
a.rangeId AS rangeId ,
d.rangeName AS rangeName ,
a.paraId AS paraId ,
e.superId AS superId ,
e.paraName AS paraName ,
b.rangeId AS rangeValue ,
a.excellent AS excellent ,
a.good AS good ,
a.average AS average ,
a.lowers AS lowers ,
a.worse AS worse
FROM indestryindicator a
INNER JOIN industry b ON a.indIndId = b.indIndId
INNER JOIN company c ON b.indId = c.indId
INNER JOIN industryrange d ON a.rangeId = d.rangeId
INNER JOIN industrypara e ON a.paraId = e.paraId
ORDER BY a.year DESC , --视图里面排序
c.com_id ,
a.rangeId ,
a.autoId ;