![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
DB
woyaosharenla
这个作者很懒,什么都没留下…
展开
-
读书笔记 SQL cookbook 1
1. 使用select * 和select 所有field 性能相同 2. 使用内联视图处理别名 select * from ( select sal as salary,comm as commision from emp) X where salary原创 2011-04-23 22:07:33 · 81 阅读 · 0 评论 -
读书笔记 SQL cookbook 2
1. order by sal desc/asc order by 3 desc/asc -- 编号由1开始 -------------------------------------------------------------------------------- 2. order by deptno asc,sal desc 注:可按select 表中...原创 2011-04-24 00:20:17 · 82 阅读 · 0 评论