一条SQL生成9*9乘法表
来源:互联网 发布:仿快乐赚php系统源码 编辑:程序博客网 时间:2024/06/08 01:00
MySQL语法:
SELECT
CASE WHEN a < 1 THEN '' ELSE CONCAT('1*',a,'=',a*1) END AS '1',
CASE WHEN a < 2 THEN '' ELSE CONCAT('2*',a,'=',a*2) END AS '2',
CASE WHEN a < 3 THEN '' ELSE CONCAT('3*',a,'=',a*3) END AS '3',
CASE WHEN a < 4 THEN '' ELSE CONCAT('4*',a,'=',a*4) END AS '4',
CASE WHEN a < 5 THEN '' ELSE CONCAT('5*',a,'=',a*5) END AS '5',
CASE WHEN a < 6 THEN '' ELSE CONCAT('6*',a,'=',a*6) END AS '6',
CASE WHEN a < 7 THEN '' ELSE CONCAT('7*',a,'=',a*7) END AS '7',
CASE WHEN a < 8 THEN '' ELSE CONCAT('8*',a,'=',a*8) END AS '8',
CASE WHEN a < 9 THEN '' ELSE CONCAT('9*',a,'=',a*9) END AS '9'
FROM (
SELECT 1 AS a
UNION ALL
SELECT 2
UNION ALL
SELECT 3
UNION ALL
SELECT 4
UNION ALL
SELECT 5
UNION ALL
SELECT 6
UNION ALL
SELECT 7
UNION ALL
SELECT 8
UNION ALL
SELECT 9
) AS t1
Oracle语法:
SELECT
CASE WHEN a < 1 THEN '' ELSE '1*'||a||'='||a*1 END AS "1",
CASE WHEN a < 2 THEN '' ELSE '2*'||a||'='||a*2 END AS "2",
CASE WHEN a < 3 THEN '' ELSE '3*'||a||'='||a*3 END AS "3",
CASE WHEN a < 4 THEN '' ELSE '4*'||a||'='||a*4 END AS "4",
CASE WHEN a < 5 THEN '' ELSE '5*'||a||'='||a*5 END AS "5",
CASE WHEN a < 6 THEN '' ELSE '6*'||a||'='||a*6 END AS "6",
CASE WHEN a < 7 THEN '' ELSE '7*'||a||'='||a*7 END AS "7",
CASE WHEN a < 8 THEN '' ELSE '8*'||a||'='||a*8 END AS "8",
CASE WHEN a < 9 THEN '' ELSE '9*'||a||'='||a*9 END AS "9"
FROM (
SELECT LEVEL a FROM DUAL connect BY LEVEL<10
)
- 一条SQL生成9*9乘法表
- 一条SQL生成九九乘法表
- 一条SQL生成九九乘法表
- 一条SQL生成九九乘法表
- sql输出9*9乘法口诀表
- 用SQL实现9*9乘法表
- 一条语句实现:乘法表打印
- 一条SQL生成N条记录
- 一条SQL快速生成大量的测试数据
- 为一条SQL语句生成AWR报告!
- SQL乘法表
- Sql 99乘法表
- 9*9乘法表
- 9*9乘法表
- 9*9乘法表
- 9*9乘法表
- 9×9乘法表
- 9*9乘法表
- TCP/IP详解
- SGU_275 To xor or not to xor gauss
- C++ 调用python VS2008工程配置
- 在XP系统下用VC6调试IIS 5.1 ISAPI扩展DLL/筛选器
- 30岁程序员的职业生涯--从开发到转型
- 一条SQL生成9*9乘法表
- 人族の好漢作者zhanqingyun
- 文档与笔记利器 reStructuredText 和 Sphinx
- 感想:30岁程序员何去何从
- UVa 156 - Ananagrams
- CouchDB的客户端用法2:PHP客户端
- TCP中32位序号详解
- Android之Wifi学习(1)
- java CallBack 回调函数的学习