常用SQL语句

1.增：

insert into GroupManage (DevID,GrpID)
values (1000,1001)

2.删：

DELETE *
FROM Dev_Grp_Relationship
WHERE DevID=10000 And GrpID=10000;

3.查：

嵌套查询：

SELECT *
FROM devices
WHERE (devices.[dev_ID]) In 
(select DevID from Dev_Grp_Relationship where GrpID = 5)

去重：distinct
select distinct devID, dev_Name
From devices
where dev_StationID = 1

Max函数：
SELECT MAX(grp_ID) AS MaxID    //注意,这里如果MaxID别名需要避过系统的关键字.否则access会用"Expr1000"来代替这一字段
FROM groupmanage;

改：

UPDATE GroupManage SET Address = 'newAddress'
WHERE id=15;