구구단 출력 2

Server	CentOS
Server Info	6.9
DB 환경	Mysql
DB Version	5.7
Language	SQL

출    처

SQL 문

SELECT  (b),'*',(a),'=',(b*a) from (                    select 1 as a from dual union all    select 2 as a from dual union all            select 3 as a from dual union all    select 4 as a from dual union all    select 5 as a from dual union all   select 6 as a from dual union all            select 7 as a from dual union all            select 8 as a from dual union all            select 9 as a from dual   ) a,     (                    select 1 as b from dual union all    select 2 as b from dual union all    select 3 as b from dual union all    select 4 as b from dual union all    select 5 as b from dual union all   select 6 as b from dual union all            select 7 as b from dual union all            select 8 as b from dual union all    select 9 as b from dual   ) b;

출력 결과