²»ºÃÒâ˼£¬ÎÒû¿´¶®ÄãµÄÒâ˼¡£ ÎÒÏÖÔÚÊÇ select * where ij×Ö¶Î <> '0000 0100' from table ÇëÎÊÒªÈçºÎÐ´ÄØ£¿ ¸ø³öÊý¾äºÍÄãÒªµÄ½á¹û ²»´ó¶®ÄãµÄÒâ˼ varchar(1)Ôõô¿ÉÒÔ×°8Î»ÄØ ÒªÊÇÊý¾ÝÖ»ÓÐÒ»¸ö×Ö·û´® Ö±½Ó select * from tb where col = '1'
SQL code:
select * from table A where ij×Ö¶Î not in( '0000 0100','0000 0
select o_customer,o_price from orders having o_price >=avg(o_price) select o_customer,o_price from orders where o_price >=(select avg(o_price) from orders) ÎҸоõûÓÐÇø±ð°¡£¬ÔõôÔÚmysql»áÓÐ ......