喋血特种慰安所,一天中什么时候最冷,武林外传疑邻盗斧
1.几个简单的基本的sql语句
选择: select * from table1 where 范围 插入: insert into table1(field1,field2) values(value1,value2) 删除: delete from table1 where 范围 更新: update table1 set field1=value1 where 范围 查找: select * from table1 where field1 like ’%value1%’ ---like的语法很精妙,查资料! 排序: select * from table1 order by field1,field2 [desc] 总数: select count as totalcount from table1 求和: select sum(field1) as sumvalue from table1 平均: select avg(field1) as avgvalue from table1 最大: select max(field1) as maxvalue from table1 最小: select min(field1) as minvalue from table1
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
SQL Server免费版的安装以及使用SQL Server Management Studio(SSMS)连接数据库的图文方法
SQL Server 2017 Developer的下载、安装、配置及SSMS的下载安装配置(图文教程详解)
网友评论