SQL语句

创建视图

create or replace view  v_groupinfo as select a.groupid,a.groupname,nvl(b.cnt,0) as count,a.indexno,a.ownerid from egroup_grouptab a left join (select
groupid,state,count(*)as cnt from egroup_staffgroupmembertab group by groupid,state)b on a.groupid=b.groupid and b.state='0' where a.state='0' order by a.ownerid,a.groupid asc

更新

update egroup_stafftab t set t.picid=' ' where t.staffaccount=' '

修改

select *from egroup_stafftab t for update

删除

delete from egroup_stafftab t where t.staffaccount=" ";