基于EMP表,编写SQL语句,如下图显示员工和他们的工资。每个“*”代表100,如:ALLEN的工资是1600,就显示16个“*”。显示结果:Employee and their salary
-----------------------------------------------------------------
KING **************************************************
BLAKE ****************************
CLARK ************************
JONES *****************************
MARTIN ************
ALLEN ****************
TURNER ***************
. . . . . . . . . .
14 rows selected.
-----------------------------------------------------------------
KING **************************************************
BLAKE ****************************
CLARK ************************
JONES *****************************
MARTIN ************
ALLEN ****************
TURNER ***************
. . . . . . . . . .
14 rows selected.
lpad('',floor(sal/100),'*') from table;;