几个简单的基本的sql语句代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】几个简单的基本的sql语句

作者:Dezai.CN / 发布于2011/11/21/ 555

<div><strong>选择：</strong>select * from table1 where 范围
<strong>插入：</strong>insert into table1(field1,field2) values(value1,value2)
<strong>删除：</strong>delete from table1 where 范围<strong>
更新</strong>：update table1 set field1=value1 where 范围
<strong>查找</strong>：select * from table1 where field1 like &rsquo;%value1%&rsquo; ---like的语法很精妙，查资料!
<strong>排序</strong>：select * from table1 order by field1,field2 [desc]
<strong>总数</strong>：select count as totalcount from table1
<strong>求和</strong>：select sum(field1) as sumvalue from table1
<strong>平均</strong>：select avg(field1) as avgvalue from table1
<strong>最大</strong>：select max(field1) as maxvalue from table1
<strong>最小</strong>：select min(field1) as minvalue from table1
</div>

试试其它关键字

　基本的sql语句　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)