select selinum from table1 where selidate between '2002-2-15' and '2002-4-29' and deptno=12ALTER TABLE table1 add No_id char(12) not null不用解释了吧,认识英文就知道啥意思