1、按条件查找:
select * from OA_GROUP_H t WHERE TAXIS between 1000 and 1015 select * from OA_GROUP_H t WHERE TAXIS=‘1000’
2、查找按降序进行排列:
select * from OA_GROUP_H t order by TAXIS DESC
3、插入数据:
insert into OA_GROUP_H(GROUP_ID,NAME,PARENT_ID,TAXIS,GROUP_TYPE,GROUP_LEVEL,GROUP_TAG,FULL_NAME) SELECT * FROM OA_GROUP WHERE TAXIS='1001'