select into 给多变量赋值

转自: http://blog.csdn.net/sufuchao/article/details/5986726

一条Select INTO语句给多个变量赋值

SELECT

SUM(SALARY),SUM(SALARY*0.1)

INTO TOTAL_SALARY,TATAL_COMMISSION

 

FROM EMPLOYEE

WHERE DEPT=10;

posted @ 2014-04-16 10:23  miss you  阅读(5418)  评论(0编辑  收藏  举报