Firebird_Language Reference RUS........................................................................................... 205 GROUP BY .............................................................................................. операциях группировки для указания специальной последовательности сортировки при выводе в предложении GROUP BY. Регистронезависимый поиск Для регистронезависимого поиска можно воспользоваться функцией UPPER: (возникает ошибка, в случае если второй аргумент больше или равен 32 Кб); • SELECT DISTINCT, ORDER BY и GROUP BY в своей работе используют BLOB ID, а не содержимое самого поля. Это одновременно и хорошо и плохо10 魔豆 | 569 页 | 3.19 MB | 2 年前3
firebird 50 language reference. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 278 6.1.6. The GROUP BY clause . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . be included with the ORDER BY clause when rows are being sorted on a character field and with the GROUP BY clause in case of grouping operations. Case-Insensitive Searching For a case-insensitive search example — 4,096 bytes, will be 169 characters. See also CREATE DATABASE, Collation, SELECT, WHERE, GROUP BY, ORDER BY 3.5.6. Character Types in Detail BINARY Data Type Declaration Format BINARY [(length)]10 魔豆 | 791 页 | 3.52 MB | 2 年前3
PostgreSQL 7.3.2 TutorialPostgreSQL Global Development Group PostgreSQL 7.3.2 Tutorial by The PostgreSQL Global Development Group Copyright © 1996-2002 by The PostgreSQL Global Development Group Legal Notice PostgreSQL is Copyright Copyright © 1996-2002 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below. Postgres95 is Copyright © 1994-5 by the Regents imitated in Postgres95 with user-defined SQL functions. Aggregates were re-implemented. Support for the GROUP BY query clause was also added. The libpq interface remained available for C programs. • In addition1 魔豆 | 40 页 | 280.71 KB | 3 年前3
PostgreSQL 15.3 DocumentationThe PostgreSQL Global Development Group PostgreSQL 15.3 Documentation The PostgreSQL Global Development Group Copyright © 1996–2023 The PostgreSQL Global Development Group Legal Notice PostgreSQL is Copyright Copyright © 1996–2023 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994–5 by the Regents of the University of California. Permission to use, copy, modify, and distribute this ..................................................................................... 1594 ALTER GROUP ............................................................................................ 15980 魔豆 | 3063 页 | 13.45 MB | 2 年前3
PostgreSQL 9.4.26 DocumentationPostgreSQL Global Development Group PostgreSQL 9.4.26 Documentation by The PostgreSQL Global Development Group Copyright © 1996-2020 The PostgreSQL Global Development Group Legal Notice PostgreSQL is is Copyright © 1996-2020 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994-5 by the Regents of the University of California. Permission to use, copy, modify, and distribute this ...................................................................................95 7.2.3. The GROUP BY and HAVING Clauses...........................................................95 7.2.4. Window Function1 魔豆 | 2452 页 | 5.99 MB | 3 年前5
firebird isqlinterface for interactive access to a Firebird database. It accepts DSQL statements along with a group of SET and SHOW commands to query and interact with the Firebird database. Some SET commands can USING PLUGIN WIN_SSPI FROM PREDEFINED_GROUP DOMAIN_ANY_RID_ADMINS TO ROLE RDB$ADMIN *** Global mapping *** WIN_ADMINS_GLOBAL USING PLUGIN WIN_SSPI FROM PREDEFINED_GROUP DOMAIN_ANY_RID_ADMINS TO ROLE RDB$ADMIN RDB$ADMIN SQL> show mapping WIN_ADMINS; WIN_ADMINS USING PLUGIN WIN_SSPI FROM PREDEFINED_GROUP DOMAIN_ANY_RID_ADMINS TO ROLE RDB$ADMIN Chapter 19. Isql Show commands 65 19.14. SHOW PROCedure SQL> SHOW10 魔豆 | 78 页 | 360.67 KB | 2 年前3
弹性负载均衡用户指南使用已有后端服务器组时,请确保此后 端服务器组未被使用。并且只能选择前 端协议匹配的后端服务器组。例如前端 协议是TCP时,后端协议只能是TCP。 新创建 名称 后端服务器组名称。 server_group-sq4v 后端协议 云服务器开通的协议。 前端协议为TCP时,后端协议默认为 TCP,不支持修改。 TCP 弹性负载均衡 用户指南 2 监听器 文档版本 18 (2022-09-07) 使用已有后端服务器组时,请确保此后 端服务器组未被使用。并且只能选择前 端协议匹配的后端服务器组。例如前端 协议是TCP时,后端协议只能是TCP。 新创建 名称 后端服务器组名称。 server_group-sq4v 弹性负载均衡 用户指南 2 监听器 文档版本 18 (2022-09-07) 版权所有 © 华为技术有限公司 41 参数 说明 示例 后端协议 云服务器开通的协议。 前端协议为TCP时,后端协议默认为 使用已有后端服务器组时,请确保此后 端服务器组未被使用。并且只能选择前 端协议匹配的后端服务器组。例如前端 协议是TCP时,后端协议只能是TCP。 新创建 名称 后端服务器组名称。 server_group-sq4v 后端协议 云服务器开通的协议。 前端协议为UDP时,后端协议支持修 改,可以选择为UDP或QUIC。 UDP 分配策略类型 负载均衡采用的算法。 ● 加权轮询算法:根据后端服务器的1 魔豆 | 227 页 | 2.87 MB | 3 年前3
firebird gstatthat only the owner — firebird — has access to the database file(s). Even members of the firebird group have no read access by default. Gstat is normally called as follows: gstat database_name [switches] being used so far — which has no duplicates. SQL> SELECT IDX, COUNT(*) CON> FROM NORMAN_TEST CON> GROUP BY IDX; IDX COUNT ============ ============ 1 1010 魔豆 | 28 页 | 159.12 KB | 2 年前3
MySQL and PHPtrademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. This software or hardware and documentation may provide access to or information about content,1 魔豆 | 8 页 | 21.69 KB | 3 年前3
Firebird on Ubuntuexact file history is recorded in the manual module in our CVS tree; see http://sourceforge.net/cvs/?group_ id=9028 Revision History 1.0 18 Apr 2007 RG First edition. 2.0–2.2 2009–2011 MP Various additions10 魔豆 | 8 页 | 38.97 KB | 2 年前3
共 14 条
- 1
- 2










