马上注册,结交更多数据大咖,获取更多知识干货,轻松玩转大数据
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
LTER SESSION SET CURRENT_SCHEMA = SqlScriptDocumentation; DROP PROCEDURE addDiscount; CREATE PROCEDURE addDiscount( IN it_books tt_sales_books, OUT ot_books tt_sales_books) LANGUAGE SQLSCRIPT READS SQL DATA AS BEGIN ot_Books = SELECT title, CASE WHEN price > 300 THEN (price - (price / 30)) ELSE CASE WHEN price > 200 THEN (price - (price / 20)) ELSE (price - (price / 10)) END END AS price, crcy FROM :it_books; END; 详细代码见:
|