无聊的6.9

hiding_nya

于 2015-06-19 23:35:10 发布

阅读量426

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库学习笔记

本文链接：https://blog.youkuaiyun.com/hiding_nya/article/details/46567085

数据库学习笔记专栏收录该内容

5 篇文章

订阅专栏

select vend_name || '(' || vend_country || ')'--把这两列调出来并且country加（）
from Vendors
order by vend_name;

--同上的作用,会去掉中间所有的空格
select RTRIM(vend_name) || '(' || RTRIM(vend_country) || ')'
from Vendors
order by vend_name;

select RTRIM(vend_name) || '(' || RTRIM(vend_country) || ')'--赋予列别名
          as vend_title
from vendors--不区分大小写
order by vend_name;

--执行计算
select prod_id,quantity,item_price,
quantity*item_price AS expanded_price
from OrderItems
where order_num =20008;