select top 40 * from
(
SELECT top 130
a1.guid,
a1.f001 as name,
a1.f002 as name2,
convert(varchar(10),a1.mtime,20) as mytimeFROM dbo.p_news001Trigger a1
INNER JOIN dbo.P_NEWS003Trigger a3
ON a1.GUID = a3.GUID
INNER JOIN dbo.P_NEWS004 a4
ON a3.F001 = a4.F001
and left(a3.f001,6)='004001'
and a1.mtime>'2007-10-7'
order by a1.mtime desc
)错误信息,就是说我最后的)前面有语法错误,但是括号里面的那组SELECT能正常执行
Msg 102, Level 15, State 1, Line 17
Incorrect syntax near ')'.
(
SELECT top 130
a1.guid,
a1.f001 as name,
a1.f002 as name2,
convert(varchar(10),a1.mtime,20) as mytimeFROM dbo.p_news001Trigger a1
INNER JOIN dbo.P_NEWS003Trigger a3
ON a1.GUID = a3.GUID
INNER JOIN dbo.P_NEWS004 a4
ON a3.F001 = a4.F001
and left(a3.f001,6)='004001'
and a1.mtime>'2007-10-7'
order by a1.mtime desc
)错误信息,就是说我最后的)前面有语法错误,但是括号里面的那组SELECT能正常执行
Msg 102, Level 15, State 1, Line 17
Incorrect syntax near ')'.
解决方案 »
- 怎样修改sql server 默认的排序规则,不重新安装行不行?
- sql 2005与msde以及会计电算化通用教学软件的问题
- excel 导出时候的问题 请大大们帮忙解决
- 请教一个简单SQL语句怎么写,谢谢
- 我的过程为什么不行呢?高手帮kankan
- 如何取得某个字段去掉最后3位字符的记录!
- 拥有相同表名的表该如何选区数据?
- [C++ Error] Unit1.cpp(24): E2288 Pointer to structure required on left side of -> or ->*是啥意思?
- 请问怎么在使用setup factory制作安装程序时创建SQL SERVER和ACCESS的ODBC数据源呢?
- left join 连接多张一对多子表时出现重复数据,求大神给个解决方案
- 如何格式化float数据
- 为什么建在一个数据库中的表在其他的数据库中也可以看到??
select top 40 * from
(
SELECT top 130
a1.guid,
a1.f001 as name,
a1.f002 as name2,
convert(varchar(10),a1.mtime,20) as mytimeFROM dbo.p_news001Trigger a1
INNER JOIN dbo.P_NEWS003Trigger a3
ON a1.GUID = a3.GUID
INNER JOIN dbo.P_NEWS004 a4
ON a3.F001 = a4.F001
and left(a3.f001,6)='004001'
and a1.mtime>'2007-10-7'
order by a1.mtime desc
)a
--加表别名
(
SELECT top 130
a1.guid,
a1.f001 as name,
a1.f002 as name2,
convert(varchar(10),a1.mtime,20) as mytimeFROM dbo.p_news001Trigger a1
INNER JOIN dbo.P_NEWS003Trigger a3
ON a1.GUID = a3.GUID
INNER JOIN dbo.P_NEWS004 a4
ON a3.F001 = a4.F001
and left(a3.f001,6)='004001'
and a1.mtime>'2007-10-7'
order by a1.mtime desc
)a
--加表别名
select top 40 * from
(
SELECT top 130
a1.guid,
a1.f001 as name,
a1.f002 as name2,
convert(varchar(10),a1.mtime,20) as mytimeFROM dbo.p_news001Trigger a1
INNER JOIN dbo.P_NEWS003Trigger a3
ON a1.GUID = a3.GUID
INNER JOIN dbo.P_NEWS004 a4
ON a3.F001 = a4.F001
and left(a3.f001,6)='004001'
and a1.mtime>'2007-10-7'
order by a1.mtime desc
) t --要加别名
order by mtime
(
SELECT top 130
a1.guid,
a1.f001 as name,
a1.f002 as name2,
convert(varchar(10),a1.mtime,20) as mytimeFROM dbo.p_news001Trigger a1
INNER JOIN dbo.P_NEWS003Trigger a3
ON a1.GUID = a3.GUID
INNER JOIN dbo.P_NEWS004 a4
ON a3.F001 = a4.F001
and left(a3.f001,6)='004001'
and a1.mtime>'2007-10-7'
order by a1.mtime desc
)ttttt--別名忘記了