判断某个表的某个字段是否和另一个表的一致;某个字段值重复出现次数

判断某个表的某个字段是否和另一个表的一致

select * from product_sku where pCode in (select pCode from product_sku_test where stock>0);

 

某个字段值重复出现次数

select pCode, count(*) as count from product_sku  group by  pCode having count>1;