无聊的6.9

select vend_name || '(' || vend_country || ')'--把这两列调出来并且country加（）from Vendorsorder by vend_name;--同上的作用,会去掉中间所有的空格select RTRIM(vend_name) || '(' || RTRIM(vend_country) || ')'from Vendorsorder by vend_name;select RTRIM(vend_name) || '(' || RTRIM(vend_country) || ')'--赋予列别名          as vend_titlefrom vendors--不区分大小写order by vend_name;--执行计算select prod_id,quantity,item_price,quantity*item_price AS expanded_pricefrom OrderItemswhere order_num =20008;