龙悦儿的专栏

insert into R_RolePermission(roleid, permissionid) select roleid, 785 as nameone from R_RolePermission where PermissionId='500'   --待更新

用SQL语句,删除掉重复项只保留一条 在几千条记录里,存在着些相同的记录,如何能用SQL语句,删除掉重复的呢 1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断 select * from people where peopleId in (select peopleId from people group by peopleId havi

sql： SELECT Name from SysColumns  WHERE id=Object_Id(tablename) order by colorder   oracle： select A.COLUMN_NAME ,A.TABLE_NAME, ROWNUM AS ROWNO from USER_TAB_COLUMNS A where TABLE_NAME = 'tab