表结构及所有记录:
id score
1 69
2 65
3 73
4 82
5 80报错:
服务器: 消息 156,级别 15,状态 1,行 4
在关键字 'AS' 附近有语法错误。
服务器: 消息 156,级别 15,状态 1,行 9
在关键字 'AS' 附近有语法错误。
我的SQL语句:SELECT Score.ID, Score.Score
FROM Score
LEFT OUTER JOIN
(
(
SELECT TOP 3 Score.ID,Score.Score
FROM Score
) AS S1
INNER JOIN
(
SELECT TOP 5 Score.ID,Score.Score
FROM Score
) AS S2
ON S1.ID = S2.ID
) AS S
ON Score.ID = S.ID
WHERE S.ID IS NULL
id score
1 69
2 65
3 73
4 82
5 80报错:
服务器: 消息 156,级别 15,状态 1,行 4
在关键字 'AS' 附近有语法错误。
服务器: 消息 156,级别 15,状态 1,行 9
在关键字 'AS' 附近有语法错误。
我的SQL语句:SELECT Score.ID, Score.Score
FROM Score
LEFT OUTER JOIN
(
(
SELECT TOP 3 Score.ID,Score.Score
FROM Score
) AS S1
INNER JOIN
(
SELECT TOP 5 Score.ID,Score.Score
FROM Score
) AS S2
ON S1.ID = S2.ID
) AS S
ON Score.ID = S.ID
WHERE S.ID IS NULL
解决方案 »
- 随机读取数据库100条记录SQL语句
- 如何将触发器或存储过程从另一台机器复制到本地sql中呢?(用语句)
- 关于sqlserver2005全文索引的问题
- 时间转换问题?
- sql重复记录查找问题,请高手进(在线等..解决就结贴)
- 求SQL写法??如何判断表table1是否在database1数据库中存在??(在线)
- db2中用脚本书写语句有什么好处呀?如何不用sql语句在表中添加行?
- 如何理解这个输出?
- 请帮我解决数据库排序规则问题,谢谢
- 初学者
- 数据库如果用windows认证,那么哪个用户有登录sql server的权限呀?不可能随便一个windows用户都能登录sql server吧?
- 自认为逻辑上,语法上都没问题的简单存储过程出问题了,求救!
FROM Score
LEFT OUTER JOIN
( select S1.ID,S1.Score
(
SELECT TOP 3 Score.ID,Score.Score
FROM Score
) AS S1
INNER JOIN
(
SELECT TOP 5 Score.ID,Score.Score
FROM Score
) AS S2
ON S1.ID = S2.ID
) AS S
ON Score.ID = S.ID
WHERE S.ID IS NULL
FROM Score
LEFT OUTER JOIN
(
select s1.id,s1.score from /*加上此行*/
(
SELECT TOP 3 Score.ID,Score.Score
FROM Score
) AS S1
INNER JOIN
(
SELECT TOP 5 Score.ID,Score.Score
FROM Score
) AS S2
ON S1.ID = S2.ID
) AS S
ON Score.ID = S.ID
WHERE S.ID IS NULL