table :
ID field1 field21 zhang 902 song 783 zhang 904 zhang 695 wang 866 zhang 99--------------------------------------------------
请教各位 要查询 field1为zhang 并且 除ID=1的 field2字段的值 的所有项 ?结果因该是ID field1 field24 zhang 696 zhang 99
ID field1 field21 zhang 902 song 783 zhang 904 zhang 695 wang 866 zhang 99--------------------------------------------------
请教各位 要查询 field1为zhang 并且 除ID=1的 field2字段的值 的所有项 ?结果因该是ID field1 field24 zhang 696 zhang 99
from tb
where field1='zhang' and id !=1
insert into tb values(1 ,'zhang' ,90)
insert into tb values(2 ,'song' ,78)
insert into tb values(3 ,'zhang' ,90)
insert into tb values(4 ,'zhang' ,69)
insert into tb values(5 ,'wang' ,86)
insert into tb values(6 ,'zhang' ,99)
goselect * from tb where field1 = 'zhang' and field2 not in (select field2 from tb where id = 1)drop table tb/*
ID field1 field2
----------- ---------- -----------
4 zhang 69
6 zhang 99(所影响的行数为 2 行)
*/
(select field2 from tb where id=1)