MySql

구구단 출력 2

zepply 2017. 9. 20. 09:46



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;



출력 결과