select * from a where dept!='b' and id

[feifeiyaqi3]

'{' 附近有语法错误为什么就不行啊？？

all{19,26}的类型和Sno 的类型相同啊，Sno int

select * from Stud where Sdept!='computer' and Sno < all {19,26};
'{' 附近有语法错误。
表代码为：
CREATE TABLE [dbo].[Stud](
[Sno] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Sname] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Ssex] [char](1) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Sage] [int] NULL,
[Sdept] [char](20) COLLATE Chinese_PRC_CI_AS NULL DEFAULT ('Computer'),
PRIMARY KEY CLUSTERED
(
[Sno] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

[我是丁学]

你这是什么语法啊？
sql server？
SQL里的不等号是 <> ，也没有{}这种东西，你想要的应该是这样的：
sql = "select * from Stud where Sdept<>'computer' and Sno < all (19,26)";

[leaohong]

语法错误，看看联机丛书吧

[colaxu]

SQL里的不等号是可以是 <> 也可以是 != .

[SOFT_LIN]

把{}改成（）应该就可以了

[feifeiyaqi3]

不行啊，我试过的(19,26)表示集合啊

[feifeiyaqi3]

sql = "select * from Stud where Sdept<>'computer' and Sno < all (19,26)";

[feifeiyaqi3]

sql = "select * from Stud where Sdept<>'computer' and Sno < all (19,26)";
这个不行啊还是有问题