⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 subquery2.out

📁 derby database source code.good for you.
💻 OUT
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------1          |1     |1                             |1                             |1                   ij> select * from s where b >= ANY (select 1 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------1          |1     |1                             |1                             |1                   ij> select * from s where i > ANY (select 1 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where i > ANY (select -1 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where c > ANY (select '1' from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where b > ANY (select 1 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where i <= ANY (select 1 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where i <= ANY (select -1 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where c <= ANY (select '1' from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where b <= ANY (select 1 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where i < ANY (select 1 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   ij> select * from s where i < ANY (select -1 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where c < ANY (select '1' from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   ij> select * from s where b < ANY (select 1 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   ij> -- constants on both sidesselect * from s where 1 = ANY (select 0 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where 0 = ANY (select 0 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------NULL       |NULL  |NULL                          |NULL                          |NULL                0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where 1 <> ANY (select 0 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------NULL       |NULL  |NULL                          |NULL                          |NULL                0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where 0 <> ANY (select 0 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where 1 >= ANY (select 0 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------NULL       |NULL  |NULL                          |NULL                          |NULL                0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where 0 >= ANY (select 0 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------NULL       |NULL  |NULL                          |NULL                          |NULL                0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where 1 > ANY (select 0 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------NULL       |NULL  |NULL                          |NULL                          |NULL                0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where 0 > ANY (select 0 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where 1 <= ANY (select 0 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where 0 <= ANY (select 0 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------NULL       |NULL  |NULL                          |NULL                          |NULL                0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where 1 < ANY (select 0 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where 0 < ANY (select 0 from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> -- compatable typesselect * from s where c = ANY (select vc from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where vc = ANY (select c from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where i = ANY (select s from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where s = ANY (select i from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where c <> ANY (select vc from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where vc <> ANY (select c from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where i <> ANY (select s from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where s <> ANY (select i from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where c >= ANY (select vc from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where vc >= ANY (select c from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where i >= ANY (select s from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where s >= ANY (select i from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where c > ANY (select vc from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------1          |1     |1                             |1                             |1                   ij> select * from s where vc > ANY (select c from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------1          |1     |1                             |1                             |1                   ij> select * from s where i > ANY (select s from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------1          |1     |1                             |1                             |1                   ij> select * from s where s > ANY (select i from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------1          |1     |1                             |1                             |1                   ij> select * from s where c <= ANY (select vc from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where vc <= ANY (select c from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where i <= ANY (select s from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where s <= ANY (select i from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where c < ANY (select vc from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where vc < ANY (select c from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where i < ANY (select s from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> select * from s where s < ANY (select i from t);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------0          |0     |0                             |0                             |0                   1          |1     |1                             |1                             |1                   ij> -- empty subquery result setselect * from s where i = ANY (select i from t where 1 = 0);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where i <> ANY (select i from t where 1 = 0);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where i >= ANY (select i from t where 1 = 0);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where i > ANY (select i from t where 1 = 0);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where i <= ANY (select i from t where 1 = 0);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> select * from s where i < ANY (select i from t where 1 = 0);I          |S     |C                             |VC                            |B                   -----------------------------------------------------------------------------------------------------ij> -- subquery under an orselect i from s where i = -1 or i = ANY (select i from t);I          -----------0          1          ij> select i from s where i = 0 or i = ANY (select i from t where i = -1);I          -----------0          ij> select i from s where i = -1 or i = ANY (select i from t where i = -1 or i = 1);
1234

⌨️ 快捷键说明

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