SQL语法错误

[blueiv]

select top 5 * from table1 where fid<(
select min(uid) from 
	(select top 10 fid from table1 order by uid desc)
)tem order by uid desc

用上面的查询说")附近有语法错误",
即使换成这样的语句也还是语法错误

select min(uid) from 
	(select top 10 fid from table1 order by uid desc)

提示和上面的是一样的 ")附近有语法错误"

[-狙击手-]

select min(uid) from 
    (select top 10 fid from table1 order by uid desc) aa

加个别名

• 打赏
• 举报

回复 赞

[-狙击手-]

select top 5 * from table1 where fid<(
select min(uid) from 
    (select top 10 fid from table1 order by uid desc) aaa
)tem order by uid desc

• 打赏
• 举报

回复 赞

[dawugui]

后面加个表别名如 T

select min(uid) from 
    (select top 10 fid from table1 order by uid desc) t

• 打赏
• 举报

回复 赞

[wzy_love_sly]

select top 5 * from table1 where fid<
(select min(fid) from (select top 10 fid from table1 order by uid desc) t
) order by uid desc

多tem 因为不表，是一个值

• 打赏
• 举报

回复 赞

[blueiv]

谢谢

• 打赏
• 举报

回复 赞