Question

用sql语句查询除某个id外的所有

Answer 1

比如stu表中除id=2外的所有元组，id为int型
select * from stu
where id not in
(select id from stu
where id=2)

Answer 2

select * from 表 where id<>某个id