sql语句中的"<>"

select g.*,p.prov_id from ex_gyjx_prod g,ut_pub_prov p

where 

g.pdt_province = p.province_name

AND g.pdt_city='ALL' 

AND g.pdt_value in (10,20,30,50,100,200,300,500)

AND g.pdt_min = '5'

AND p.prov_id <> '0'

order by g.pdt_isp,p.prov_id,g.pdt_value

其中 “ <> ” 是不等于的意思