dml038.out

来自「derby database source code.good for you.」· OUT 代码 · 共 385 行

OUT
385 行
字号 
ij> -- MODULE DML038-- SQL Test Suite, V6.0, Interactive SQL, dml038.sql-- 59-byte ID-- TEd Version #-- AUTHORIZATION HU   set schema HU;0 rows inserted/updated/deletedij> --O   SELECT USER FROM HU.ECCO;  VALUES USER;1                                                                                                                               --------------------------------------------------------------------------------------------------------------------------------HU                                                                                                                              ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment-- date_time print-- TEST:0205 Cartesian product is produced without WHERE clause!     SELECT GRADE, HOURS, BUDGET          FROM STAFF, WORKS, PROJ order by GRADE, HOURS, BUDGET;GRADE|HOURS |BUDGET    -----------------------10   |12    |10000     10   |12    |10000     10   |12    |10000     10   |12    |10000     10   |12    |20000     10   |12    |20000     10   |12    |30000     10   |12    |30000     10   |12    |30000     10   |12    |30000     10   |12    |50000     10   |12    |50000     10   |20    |10000     10   |20    |10000     10   |20    |10000     10   |20    |10000     10   |20    |10000     10   |20    |10000     10   |20    |10000     10   |20    |10000     10   |20    |20000     10   |20    |20000     10   |20    |20000     10   |20    |20000     10   |20    |30000     10   |20    |30000     10   |20    |30000     10   |20    |30000     10   |20    |30000     10   |20    |30000     10   |20    |30000     10   |20    |30000     10   |20    |50000     10   |20    |50000     10   |20    |50000     10   |20    |50000     10   |40    |10000     10   |40    |10000     10   |40    |10000     10   |40    |10000     10   |40    |10000     10   |40    |10000     10   |40    |20000     10   |40    |20000     10   |40    |20000     10   |40    |30000     10   |40    |30000     10   |40    |30000     10   |40    |30000     10   |40    |30000     10   |40    |30000     10   |40    |50000     10   |40    |50000     10   |40    |50000     10   |80    |10000     10   |80    |10000     10   |80    |10000     10   |80    |10000     10   |80    |10000     10   |80    |10000     10   |80    |20000     10   |80    |20000     10   |80    |20000     10   |80    |30000     10   |80    |30000     10   |80    |30000     10   |80    |30000     10   |80    |30000     10   |80    |30000     10   |80    |50000     10   |80    |50000     10   |80    |50000     12   |12    |10000     12   |12    |10000     12   |12    |10000     12   |12    |10000     12   |12    |10000     12   |12    |10000     12   |12    |10000     12   |12    |10000     12   |12    |20000     12   |12    |20000     12   |12    |20000     12   |12    |20000     12   |12    |30000     12   |12    |30000     12   |12    |30000     12   |12    |30000     12   |12    |30000     12   |12    |30000     12   |12    |30000     12   |12    |30000     12   |12    |50000     12   |12    |50000     12   |12    |50000     12   |12    |50000     12   |20    |10000     12   |20    |10000     12   |20    |10000     12   |20    |10000     12   |20    |10000     12   |20    |10000     12   |20    |10000     12   |20    |10000     12   |20    |10000     12   |20    |10000     12   |20    |10000     12   |20    |10000     12   |20    |10000     12   |20    |10000     12   |20    |10000     12   |20    |10000     12   |20    |20000     12   |20    |20000     12   |20    |20000     12   |20    |20000     12   |20    |20000     12   |20    |20000     12   |20    |20000     12   |20    |20000     12   |20    |30000     12   |20    |30000     12   |20    |30000     12   |20    |30000     12   |20    |30000     12   |20    |30000     12   |20    |30000     12   |20    |30000     12   |20    |30000     12   |20    |30000     12   |20    |30000     12   |20    |30000     12   |20    |30000     12   |20    |30000     12   |20    |30000     12   |20    |30000     12   |20    |50000     12   |20    |50000     12   |20    |50000     12   |20    |50000     12   |20    |50000     12   |20    |50000     12   |20    |50000     12   |20    |50000     12   |40    |10000     12   |40    |10000     12   |40    |10000     12   |40    |10000     12   |40    |10000     12   |40    |10000     12   |40    |10000     12   |40    |10000     12   |40    |10000     12   |40    |10000     12   |40    |10000     12   |40    |10000     12   |40    |20000     12   |40    |20000     12   |40    |20000     12   |40    |20000     12   |40    |20000     12   |40    |20000     12   |40    |30000     12   |40    |30000     12   |40    |30000     12   |40    |30000     12   |40    |30000     12   |40    |30000     12   |40    |30000     12   |40    |30000     12   |40    |30000     12   |40    |30000     12   |40    |30000     12   |40    |30000     12   |40    |50000     12   |40    |50000     12   |40    |50000     12   |40    |50000     12   |40    |50000     12   |40    |50000     12   |80    |10000     12   |80    |10000     12   |80    |10000     12   |80    |10000     12   |80    |10000     12   |80    |10000     12   |80    |10000     12   |80    |10000     12   |80    |10000     12   |80    |10000     12   |80    |10000     12   |80    |10000     12   |80    |20000     12   |80    |20000     12   |80    |20000     12   |80    |20000     12   |80    |20000     12   |80    |20000     12   |80    |30000     12   |80    |30000     12   |80    |30000     12   |80    |30000     12   |80    |30000     12   |80    |30000     12   |80    |30000     12   |80    |30000     12   |80    |30000     12   |80    |30000     12   |80    |30000     12   |80    |30000     12   |80    |50000     12   |80    |50000     12   |80    |50000     12   |80    |50000     12   |80    |50000     12   |80    |50000     13   |12    |10000     13   |12    |10000     13   |12    |10000     13   |12    |10000     13   |12    |10000     13   |12    |10000     13   |12    |10000     13   |12    |10000     13   |12    |20000     13   |12    |20000     13   |12    |20000     13   |12    |20000     13   |12    |30000     13   |12    |30000     13   |12    |30000     13   |12    |30000     13   |12    |30000     13   |12    |30000     13   |12    |30000     13   |12    |30000     13   |12    |50000     13   |12    |50000     13   |12    |50000     13   |12    |50000     13   |20    |10000     13   |20    |10000     13   |20    |10000     13   |20    |10000     13   |20    |10000     13   |20    |10000     13   |20    |10000     13   |20    |10000     13   |20    |10000     13   |20    |10000     13   |20    |10000     13   |20    |10000     13   |20    |10000     13   |20    |10000     13   |20    |10000     13   |20    |10000     13   |20    |20000     13   |20    |20000     13   |20    |20000     13   |20    |20000     13   |20    |20000     13   |20    |20000     13   |20    |20000     13   |20    |20000     13   |20    |30000     13   |20    |30000     13   |20    |30000     13   |20    |30000     13   |20    |30000     13   |20    |30000     13   |20    |30000     13   |20    |30000     13   |20    |30000     13   |20    |30000     13   |20    |30000     13   |20    |30000     13   |20    |30000     13   |20    |30000     13   |20    |30000     13   |20    |30000     13   |20    |50000     13   |20    |50000     13   |20    |50000     13   |20    |50000     13   |20    |50000     13   |20    |50000     13   |20    |50000     13   |20    |50000     13   |40    |10000     13   |40    |10000     13   |40    |10000     13   |40    |10000     13   |40    |10000     13   |40    |10000     13   |40    |10000     13   |40    |10000     13   |40    |10000     13   |40    |10000     13   |40    |10000     13   |40    |10000     13   |40    |20000     13   |40    |20000     13   |40    |20000     13   |40    |20000     13   |40    |20000     13   |40    |20000     13   |40    |30000     13   |40    |30000     13   |40    |30000     13   |40    |30000     13   |40    |30000     13   |40    |30000     13   |40    |30000     13   |40    |30000     13   |40    |30000     13   |40    |30000     13   |40    |30000     13   |40    |30000     13   |40    |50000     13   |40    |50000     13   |40    |50000     13   |40    |50000     13   |40    |50000     13   |40    |50000     13   |80    |10000     13   |80    |10000     13   |80    |10000     13   |80    |10000     13   |80    |10000     13   |80    |10000     13   |80    |10000     13   |80    |10000     13   |80    |10000     13   |80    |10000     13   |80    |10000     13   |80    |10000     13   |80    |20000     13   |80    |20000     13   |80    |20000     13   |80    |20000     13   |80    |20000     13   |80    |20000     13   |80    |30000     13   |80    |30000     13   |80    |30000     13   |80    |30000     13   |80    |30000     13   |80    |30000     13   |80    |30000     13   |80    |30000     13   |80    |30000     13   |80    |30000     13   |80    |30000     13   |80    |30000     13   |80    |50000     13   |80    |50000     13   |80    |50000     13   |80    |50000     13   |80    |50000     13   |80    |50000     ij> -- PASS:0205 If 360 rows are selected ?-- END TEST >>> 0205 <<< END TEST-- *************************************************////END-OF-MODULE;ij>

dml038.out - 源码说明

本页面展示了「derby database source code.good for you.」中的 dml038.out 源码文件，采用 OUT 编程语言编写，共 385 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与database相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?