1、基本SQL语句查询表1、Select * from 职工2、Select 职工号,姓名,工资 from 职工And、andnotSelect * from 职工号 where(仓库号='wh1' or 仓库号='wh2') And not 性别='女' and 工资>=1300 and 工资<=2100OrinSelect * from 订购单 where 职工号='zg1' or 职工号='zg2' Or 职工号='zg11' or 职工号='zg15'Select * from 订购单 where 职工号 in('zg1', 'zg2', 'zg11', 'zg15')Select * f
2、rom 订购单 where 职工号!='zg1' or 职工号!='zg2' Or 职工号!='zg11' or 职工号!='zg15'Select * from 订购单 where 职工号 not in('zg1', 'zg2', 'zg11', 'zg15') 模糊查询通配符：%_[][^]Select * from 职工 where 姓名 not like'王%'Select * from 职工 where 姓名 not like'王%_'空值null查询Select * from 职工 where 姓名isnullBetween…andSelect * from 职工 where 工资
