当前位置: 技术问答>java相关
!!!!!!!SQL语句的问题,在线等待!!!!!!
来源: 互联网 发布时间:2015-08-02
本文导语: 要求一SQL语句,查出表A中 opCode != 300的所有纪录!!! | select * from A where userid not in (select userid from A where requireRight 300) or (opCode not in (530,7...
要求一SQL语句,查出表A中 opCode != 300的所有纪录!!!
|
select * from A where userid not in (select userid from A where requireRight 300) or (opCode not
in (530,730,830));
in (530,730,830));