基本SQL语句

最新推荐文章于 2022-06-09 23:02:35 发布

AinSnow

最新推荐文章于 2022-06-09 23:02:35 发布

阅读量594

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/AinSnow/article/details/40053089

版权

数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

基本的SQL语句insert,select,delete,update

select * from Table_1
insert into Table_1 (Name,Age,Sex) values('Jack',45,'boy')
select * from Table_1
insert into Table_1 (Name,Age,Sex) values('Tont',12,'boy')
select * from Table_1
update Table_1 set Age=Age+1
select * from Table_1
delete from Table_1  where Age=13
select Age from Table_1
select * from Table_1
select MAX(Age) from Table_1
select MIN (Age) from Table_1
select AVG(Age) from Table_1
select COUNT (*) from Table_1
select * from Table_1
select * from Table_1 where Name like 'J%'
select * from Table_1 order by Age desc,Sex

MAX(),MIN(),AVG(),COUNT() :sql server内置数据汇总语句

like 'j%' :模糊查询，%通配符

order by :默认ase升序，后面加desc降序排序