1.in(value1,value2)
Delete Employ where id in(21,22)
2.and,between..and..
范围值:
SELECT * FROM T_Employee WHERE FAGE>=23 AND FAGE <=27
SELECT * FROM T_Employee WHERE FAGE BETWEEN 23 AND 27
1.in(value1,value2)
Delete Employ where id in(21,22)
2.and,between..and..
范围值:
SELECT * FROM T_Employee WHERE FAGE>=23 AND FAGE <=27
SELECT * FROM T_Employee WHERE FAGE BETWEEN 23 AND 27
转载于:https://www.cnblogs.com/DaiMaDi/archive/2013/02/28/2936756.html