文件名称：sqlserver数据库常用增删改查
文件大小：22KB
文件格式：TXT
更新时间：2020-04-26 02:00:45
sqlserver
DISTINCT去除重复的 SELECT DISTINCT "栏位名" FROM "表格名" SELECT DISTINCT store_name FROM Store_Information WHERE条件语句 SELECT "栏位名" FROM "表格名" WHERE "条件" SELECT store_name FROM Store_Information WHERE Sales > 1000 AND|OR且或 SELECT "栏位名" FROM "表格名" WHERE "简单条件" {[AND|OR] "简单条件"} SELECT store_name FROM Store_Information WHERE Sales > 1000 OR (Sales < 500 AND Sales > 275) IN在条件里 SELECT "栏位名" FROM "表格名" WHERE "栏位名" IN ('值一', '值二', ...) SELECT * FROM Store_Information WHERE store_name IN ('Los Angeles', 'San Diego') BETWEEN两者之间 SELECT "栏位名" FROM "表格名" WHERE "栏位名" BETWEEN '值一' AND '值二' SELECT * FROM Store_Information WHERE Date BETWEEN 'Jan-06-1999' AND 'Jan-10-1999' LIKE模糊查询 SELECT "栏位名" FROM "表格名" WHERE "栏位名" LIKE {套式} '%AN%' SELECT * FROM Store_Information WHERE store_name LIKE '%AN%' ASC从小到大DESC从大到小 SELECT "栏位名" FROM "表格名" [WHERE "条件"] ORDER BY "栏位名" ASC,DESC SELECT store_name, Sales, Date FROM Store_Information ORDER BY Sales DESC AVG (平均) COUNT (计数)MAX (最大值) MIN (最小值) SUM (总合) SELECT "函数名"("栏位名") FROM "表格名" SELECT SUM(Sales) FROM Store_Information COUNT统计数量 SELECT COUNT("栏位名") FROM "表格名" SELECT COUNT(store_name) FROM Store_Information WHERE store_name is not NULL