- 博客(2)
- 收藏
- 关注
转载 ORACLE 在WHERE子句中引用列别名问题
来源:http://blog.sina.com.cn/s/blog_5384afff0100y6o9.html作者:ygslSQL> SELECT SAL SALARY FROM EMP WHERE SALARYWarning: connection was lost and re-establishedSELECT SAL SALARY F
2015-09-11 10:17:26 826
原创 Oracle select distinct
做项目,写oracle查询语句的时候,总是喜欢滥用distinct关键字。但后来发现,某些场合下,distinct的性能开销非常大。with diag_list as (select distinct diagnosis_desc from medrec.diagnosis where diagnosis_desc is not null),diag_dict as (select d
2015-09-09 11:06:49 943
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人