- 如何打造数据治理闭环?以保[2022-06-16]
- 什么样的公司需要数据治理?[2022-06-15]
- “互联网+政务服务”下的数[2022-06-14]
- 我国数据安全治理研究[2022-06-13]
- 反洗钱视角下的数据治理[2022-06-10]
- 浅谈数据质量管理[2022-06-08]
- 做数据治理前,必须了解并避[2022-06-07]
- 企业数据治理团队的十大职[2022-06-06]
- 浅谈数据质量管理[2022-06-02]
- 数据治理的三种共享范式[2022-06-01]
30种SQL语句优化
select id from t where num is null
select id from t where num=0
select id from t where num=10 or num=20
select id from t where num=10
union all
select id from t where num=20
select id from t where name like '%abc%'
select id from t where num in(1,2,3)
select id from t where num between 1 and 3
select id from t where num=@num
select id from t with(index(索引名)) where num=@num
select id from t where num/2=100
select id from t where num=100*2
select id from t where substring(name,1,3)='abc'
--name以abc开头的id
select id from t where datediff(day,createdate,'2005-11-30')=0
--'2005-11-30'生成的id
select id from t where name like 'abc%'
select id from t where createdate>='2005-11-30' and createdate<'2005-12-1'
select col1,col2 into #t from t where 1=0
create table #t(...)
select num from a where num in(select num from b)
select num from a where exists(select 1 from b where num=a.num)
中翰软件:专注数据治理15年(http://www.jobhand.cn)