您所在位置：主题：[讨论]sql查询出现错误请高手指教~
evaf
[专家分：0] 发布于 2006-05-19 11:20:00
SELECT TOP 8 guest_name, guest_id
FROM guest_info
WHERE (guest_id NOT IN
(SELECT TOP[b] 8*4 [/b]guest_id
FROM guest_info
ORDER BY guest_id))
ORDER BY guest_id
服务器: 消息 170，级别 15，状态 1，行 5
第 5 行: '4' 附近有语法错误。
错误处:粗体处 谢谢~
FROM guest_info
WHERE (guest_id NOT IN
(SELECT TOP[b] 8*4 [/b]guest_id
FROM guest_info
ORDER BY guest_id))
ORDER BY guest_id
服务器: 消息 170，级别 15，状态 1，行 5
第 5 行: '4' 附近有语法错误。
错误处:粗体处 谢谢~
