![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
shucaifanzi
这个作者很懒,什么都没留下…
展开
-
sql存储过程
CREATE PROC [ EDURE ] procedure_name [ ; number ] 2 [ { @parameter data_type } 3 [ VARYING ] [ = default ] [ OUTPUT ] 4 ] [ ,...n ] 5 [ WITH 6 { RECOMPILE | ENCRYPTION | RECOM...转载 2019-01-03 20:38:29 · 186 阅读 · 0 评论 -
sql查询相同和不同数据
**两张表**方法一select distinct A.ID from A where A.ID not in (select ID from B)方法二:select A.ID from A left join B on A.ID=B.ID where B.ID is null方法三:select * from B where (select count(1) as n...转载 2019-01-04 18:22:43 · 6227 阅读 · 0 评论