DB关键字对比

最新推荐文章于 2022-06-30 20:39:40 发布

Plateau_Han

最新推荐文章于 2022-06-30 20:39:40 发布

阅读量611

点赞数

分类专栏：大类文章标签： DB

本文链接：https://blog.csdn.net/Plateau_Han/article/details/90054571

版权

大类专栏收录该内容

1 篇文章 0 订阅

订阅专栏

                    
                        
                    
                    SQLServerOracle
selectselect
updateupdate
drop/truncate/deletedrop/truncate/delete
insert intoinsert into
createcreate
（left/right/inner）join…on（left/right/inner）join …on
union (all)union (all)
order by（asc/desc）order by（asc/desc）
sum/avg/max/min/conut…group by…havingsum/avg/max/min/conut…group by…having
existsexists
case when…then…else…endcase when…then…else…end
convert/castto_char
getdate()select sysdate from dual
isnull()nvl()
is nullis null
toprownum
round(culomn,0)
substringsubstr
between…and…between…and…
insert into #table select…from…with table as (select … from …)
无decode(column,条件1,值1,条件2，值2,…,值其他)

                

SQLServer	Oracle
select	select
update	update
drop/truncate/delete	drop/truncate/delete
insert into	insert into
create	create
（left/right/inner）join…on	（left/right/inner）join …on
union (all)	union (all)
order by（asc/desc）	order by（asc/desc）
sum/avg/max/min/conut…group by…having	sum/avg/max/min/conut…group by…having
exists	exists
case when…then…else…end	case when…then…else…end
convert/cast	to_char
getdate()	select sysdate from dual
isnull()	nvl()
is null	is null
top	rownum
	round(culomn,0)
substring	substr
between…and…	between…and…
insert into #table select…from…	with table as (select … from …)
无	decode(column,条件1,值1,条件2，值2,…,值其他)