select x.tno,x.score as xscore,y.score as yscore from evaluate as x,evaluate as y where (x.score>y.score) and (y.tno='14')
如上查询语句为表的自身连接查询语句,但是sql报错了,内容为sql命令未正确结束,为什么?求高手指教!
如上查询语句为表的自身连接查询语句,但是sql报错了,内容为sql命令未正确结束,为什么?求高手指教!
解决方案 »
- SQL Server数据库数据导入导出问题,急求解决办法或工具!
- 请教一个小问题
- sql server varchar 类型默认值 要求 convert(varchar,1000000000000+ID)+convert(varchar,getdate(),112)
- 我们公司的SQL在执行数据的时候总是堵塞,到底如何解决这个问题啊,救命啊!!
- 一个简单的字符截取的问题
- sql异常
- 请教如何更新表中不为空的字段值呢?
- 那里有sql标准99版或92版下载?
- 这种合并的语句怎么写?谢谢!
- SQL Server 2k可以定义255以上长度的varchar,但是客户端最多只能取出255字节!怎么解决呀?
- sql server存储过程中创建列名不确定的临时表
- 关于数据库登录不上的问题
-- Author :DBA_Huangzj(發糞塗牆)
-- Date :2013-08-06 07:47:06
-- Version:
-- Microsoft SQL Server 2014 (CTP1) - 11.0.9120.5 (X64)
-- Jun 10 2013 20:09:10
-- Copyright (c) Microsoft Corporation
-- Enterprise Evaluation Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
--
----------------------------------------------------------------
--> 测试数据:[evaluate]
if object_id('[evaluate]') is not null drop table [evaluate]
go
create table [evaluate]([tno] int,[score] int)
insert [evaluate]
select 1,123 union all
select 14,12312 union all
select 2,452314
--------------开始查询--------------------------select x.tno,x.score as xscore,y.score as yscore from evaluate as x,evaluate as y where (x.score>y.score) and (y.tno='14')
----------------结果----------------------------
/*
tno xscore yscore
----------- ----------- -----------
2 452314 12312
*/
--没有问题啊,有可能是全角空格造成的,试试下面的
select x.tno,x.score as xscore,y.score as yscore
from evaluate as x,evaluate as y
where x.score>y.score and y.tno='14'
SELECT x.tno ,
x.score AS xscore ,
y.score AS yscore
FROM evaluate AS x ,
evaluate AS y
WHERE ( x.score > y.score )
AND ( y.tno = '14' ) --是在程序里调用的吗?注释掉这行试试
x.score AS xscore ,
y.score AS yscore
FROM evaluate x , --把as 去掉
evaluate y
WHERE ( x.score > y.score )
AND ( y.tno = '14' )