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;