随笔分类 -  SQL

摘要：1.增：insert into GroupManage (DevID,GrpID)values (1000,1001)2.删：DELETE *FROM Dev_Grp_RelationshipWHERE DevID=10000 And GrpID=10000;3.查：嵌套查询：SELECT *FROM devicesWHERE (devices.[dev_ID]) In (select DevID from Dev_Grp_Relationship where GrpID = 5)去重：distinctselect distinct devID, dev_NameFrom deviceswhe 阅读全文