mysql有rollup函数,Mysql,Oracle使用rollup函数完成行列统计

最新推荐文章于 2024-02-03 10:40:46 发布
最新推荐文章于 2024-02-03 10:40:46 发布
阅读量430 收藏 2
点赞数
文章标签： mysql有rollup函数

时间 2014-02-25 00:05:38  ITeye-博客

昨天突然在 一篇博客中看到了Mysql也有rollup函数，原博文使用了rollup进行行列统计，原博文链接如下：

本博文主要是记录下mysql和oracle使用rollup函数进行行列统计，内容比较简单。

首先是mysql，建表测试：

CREATE TABLE `tmysql_test_hanglietongji` (

`id` int(11) NOT NULL,

`c1` char(2) COLLATE utf8_bin DEFAULT NULL,

`c2` char(2) COLLATE utf8_bin DEFAULT NULL,

`c3` int(11) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin

INSERT INTO `tmysql_test_hanglietongji` VALUES (1, ‘A1‘, ‘B1‘, 9);

INSERT INTO `tmysql_test_hanglietongji` VALUES (2, ‘A2‘, ‘B1‘, 7);

INSERT INTO `tmysql_test_hanglietongji` VALUES (3, ‘A3‘, ‘B1‘, 4);

INSERT INTO `tmysql_test_hanglietongji` VALUES (4, ‘A4‘, ‘B1‘, 2);

INSERT INTO `tmysql_test_hanglietongji` VALUES (5, ‘A1‘, ‘B2‘, 2);

INSERT INTO `tmysql_test_hanglietongji` VALUES (6, ‘A2‘, ‘B2‘, 9);

INSERT INTO `tmysql_test_hanglietongji` VALUES (7, ‘A3‘, ‘B2‘, 8);

INSERT INTO `tmysql_test_hanglietongji` VALUES (8, ‘A4‘, ‘B2‘, 5);

INSERT INTO `tmysql_test_hanglietongji` VALUES (9, ‘A1‘, ‘B3‘, 1);

INSERT INTO `tmysql_test_hanglietongji` VALUES (10, ‘A2‘, ‘B3‘, 8);

INSERT INTO `tmysql_test_hanglietongji` VALUES (11, ‘A3‘, ‘B3‘, 8);

INSERT INTO `tmysql_test_hanglietongji` VALUES (12, ‘A4‘, ‘B3‘, 6);

INSERT INTO `tmysql_test_hanglietongji` VALUES (13, ‘A1‘, ‘B4‘, 8);

INSERT INTO `tmysql_test_hanglietongji` VALUES (14, ‘A2‘, ‘B4‘, 2);

INSERT INTO `tmysql_test_hanglietongji` VALUES (15, ‘A3‘, ‘B4‘, 6);

INSERT INTO `tmysql_test_hanglietongji` VALUES (16, ‘A4‘, ‘B4‘, 9);

INSERT INTO `tmysql_test_hanglietongji` VALUES (17, ‘A1‘, ‘B4‘, 3);

INSERT INTO `tmysql_test_hanglietongji` VALUES (18, ‘A2‘, ‘B4‘, 5);

INSERT INTO `tmysql_test_hanglietongji` VALUES (19, ‘A3‘, ‘B4‘, 2);

INSERT INTO `tmysql_test_hanglietongji` VALUES (20, ‘A4‘, ‘B4‘, 5);

要完成的效果如下：

5d997dff9e771d743c66e47b253efbe3.png

最简单的是使用union,如下：

select ifnull(c1, ‘total‘) as ‘total‘,

sum(if(c2 = ‘B1‘, C3, 0)) AS B1,

sum(if(c2 = ‘B2‘, C3, 0)) AS B2,

sum(if(c2 = ‘B3‘, C3, 0)) AS B3,

sum(if(c2 = ‘B4‘, C3, 0)) AS B4,

SUM(C3) AS TOTAL

from tmysql_test_hanglietongji

group by C1

union

select ‘total‘ as ‘total‘,

sum(if(c2 = ‘B1‘, C3, 0)) AS B1,

sum(if(c2 = ‘B2‘, C3, 0)) AS B2,

sum(if(c2 = ‘B3‘, C3, 0)) AS B3,

sum(if(c2 = ‘B4‘, C3, 0)) AS B4,

SUM(C3) AS TOTAL

from tmysql_test_hanglietongji

order by 1

也可以使用with rollup函数。注意当使用 rollup时, 你不能同时使用 order by子句进行结果排序

select ifnull(c1, ‘total‘) ‘total‘,

sum(if(c2 = ‘B1‘, C3, 0)) AS B1,

sum(if(c2 = ‘B2‘, C3, 0)) AS B2,

sum(if(c2 = ‘B3‘, C3, 0)) AS B3,

sum(if(c2 = ‘B4‘, C3, 0)) AS B4,

SUM(C3) AS TOTAL

from tmysql_test_hanglietongji

group by C1 with rollup;

with rollup其实是第一个的简化。

也可以这样写：

SELECT IFNULL(c1, ‘total‘) AS total,

SUM(IF(c2 = ‘B1‘, c3, 0)) AS B1,

SUM(IF(c2 = ‘B2‘, c3, 0)) AS B2,

SUM(IF(c2 = ‘B3‘, c3, 0)) AS B3,

SUM(IF(c2 = ‘B4‘, c3, 0)) AS B4,

SUM(IF(c2 = ‘total‘, c3, 0)) AS total

FROM (SELECT c1, IFNULL(c2, ‘total‘) AS c2, SUM(c3) AS c3

FROM tmysql_test_hanglietongji

GROUP BY c1, c2 WITH ROLLUP

HAVING c1 IS NOT NULL) AS A

GROUP BY c1 WITH ROLLUP;

HAVING c1 IS NOT NULL条件主要是过滤掉对整个tmysql_test_hanglietongji 表求和的那一行，以上面的子查询为例：

SELECT c1, IFNULL(c2, ‘total‘) AS c2, SUM(c3) AS c3

FROM tmysql_test_hanglietongji

GROUP BY c1, c2 WITH ROLLUP

结果是：

99dba9204d148f701168f88bbc341b60.png 

相当于：

SELECT c1, IFNULL(c2, ‘total‘) AS c2, SUM(c3) AS c3

FROM tmysql_test_hanglietongji

GROUP BY c1, c2

union ALL

SELECT c1, ‘total‘ AS c2, SUM(c3) AS c3

FROM tmysql_test_hanglietongji

GROUP BY c1

union ALL

SELECT NULL, ‘total‘ AS c2, SUM(c3) AS c3

FROM tmysql_test_hanglietongji

结果是：

b3db29daa99e5f9f382bf8b613085604.png 

可以看出group by c1,c2 with rollup相当于group by c1,c2 union group by c1(c2替换为NULL) union (c1,c2全部替换为NULL)。

这里的替换规则参考了链接

原文是替换Oracle的rollup，在Mysql中也适用。

使用普通sql写法是：

SELECT IFNULL(c1, ‘total‘) AS total,

SUM(IF(c2 = ‘B1‘, c3, 0)) AS B1,

SUM(IF(c2 = ‘B2‘, c3, 0)) AS B2,

SUM(IF(c2 = ‘B3‘, c3, 0)) AS B3,

SUM(IF(c2 = ‘B4‘, c3, 0)) AS B4,

SUM(IF(c2 = ‘total‘, c3, 0)) AS total

FROM (SELECT c1, IFNULL(c2, ‘total‘) AS c2, SUM(c3) AS c3

FROM tmysql_test_hanglietongji

GROUP BY c1, c2

HAVING c1 IS NOT NULL

union

SELECT c1, ‘total‘ as c2, SUM(c3) AS c3

FROM tmysql_test_hanglietongji

group by c1) A

group by c1

UNION

SELECT ‘total‘ as total,

SUM(IF(c2 = ‘B1‘, c3, 0)) AS B1,

SUM(IF(c2 = ‘B2‘, c3, 0)) AS B2,

SUM(IF(c2 = ‘B3‘, c3, 0)) AS B3,

SUM(IF(c2 = ‘B4‘, c3, 0)) AS B4,

SUM(IF(c2 = ‘total‘, c3, 0)) AS total

FROM (SELECT c1, IFNULL(c2, ‘total‘) AS c2, SUM(c3) AS c3

FROM tmysql_test_hanglietongji

GROUP BY c1, c2

HAVING c1 IS NOT NULL

union

SELECT c1, ‘total‘ as c2, SUM(c3) AS c3

FROM tmysql_test_hanglietongji

group by c1) A

少了一个是因为上面的having要求c1 is not null,所以替换c1为NULL就没有了。

下面看下oracle中怎么写，想要的效果如图：

88bf7b33bbb29b4284ef5f57b2492cdf.png

首先建表。

create table TSQL_TEST_HANGLIETONGJI

(

ID NUMBER(4) not null,

C1 VARCHAR2(2),

C2 VARCHAR2(2),

C3 NUMBER(4)

)

;

alter table TSQL_TEST_HANGLIETONGJI

add primary key (ID);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (1, ‘A1‘, ‘B1‘, 9);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (2, ‘A2‘, ‘B1‘, 7);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (3, ‘A3‘, ‘B1‘, 4);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (4, ‘A4‘, ‘B1‘, 2);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (5, ‘A1‘, ‘B2‘, 2);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (6, ‘A2‘, ‘B2‘, 9);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (7, ‘A3‘, ‘B2‘, 8);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (8, ‘A4‘, ‘B2‘, 5);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (9, ‘A1‘, ‘B3‘, 1);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (10, ‘A2‘, ‘B3‘, 8);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (11, ‘A3‘, ‘B3‘, 8);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (12, ‘A4‘, ‘B3‘, 6);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (13, ‘A1‘, ‘B4‘, 8);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (14, ‘A2‘, ‘B4‘, 2);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (15, ‘A3‘, ‘B4‘, 6);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (16, ‘A4‘, ‘B4‘, 9);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (17, ‘A1‘, ‘B4‘, 3);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (18, ‘A2‘, ‘B4‘, 5);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (19, ‘A3‘, ‘B4‘, 2);

insert into TSQL_TEST_HANGLIETONGJI (ID, C1, C2, C3)

values (20, ‘A4‘, ‘B4‘, 5);

最简单的写法是：

select c1,

sum(decode(c2,‘B1‘, C3, 0)) AS B1,

sum(decode(c2 ,‘B2‘, C3, 0)) AS B2,

sum(decode(c2 ,‘B3‘, C3, 0)) AS B3,

sum(decode(c2 ,‘B4‘, C3, 0)) AS B4,

SUM(C3) AS TOTAL

from tsql_test_hanglietongji

group by C1

UNION

SELECT ‘TOTAL‘,

sum(decode(c2 ,‘B1‘, C3, 0)) AS B1,

sum(decode(c2 ,‘B2‘, C3, 0)) AS B2,

sum(decode(c2 ,‘B3‘, C3, 0)) AS B3,

sum(decode(c2 ,‘B4‘, C3, 0)) AS B4,

SUM(C3)

FROM tsql_test_hanglietongji

然后使用rollup函数简化。

SELECT nvl(c1, ‘total‘) AS total,

SUM(decode(c2, ‘B1‘, c3, 0)) AS B1,

SUM(decode(c2, ‘B2‘, c3, 0)) AS B2,

SUM(decode(c2, ‘B3‘, c3, 0)) AS B3,

SUM(decode(c2, ‘B4‘, c3, 0)) AS B4,

sum(c3) AS total

FROM tsql_test_hanglietongji

GROUP BY ROLLUP(c1)

也可以这么写：

SELECT nvl(c1, ‘total‘) AS total_c,

SUM(decode(c2, ‘B1‘, c3, 0)) AS B1,

SUM(decode(c2, ‘B2‘, c3, 0)) AS B2,

SUM(decode(c2, ‘B3‘, c3, 0)) AS B3,

SUM(decode(c2, ‘B4‘, c3, 0)) AS B4,

SUM(decode(c2, ‘total‘, c3, 0)) AS total_r

FROM (SELECT c1, nvl(c2, ‘total‘) AS c2, SUM(c3) AS c3

FROM tsql_test_hanglietongji

GROUP BY ROLLUP(c1, c2)

HAVING c1 IS NOT NULL) A

GROUP BY ROLLUP(c1);

rollup和普通sql替换上面也说了，举个例子：

SELECT c1, nvl(c2, ‘total‘) AS c2, SUM(c3) AS c3

FROM tsql_test_hanglietongji

GROUP BY ROLLUP(c1, c2)

效果是：

32e8aad2ad5e104e91c56d5758f7db0c.png 

普通sql写法是：

SELECT c1, nvl(c2, ‘total‘) AS c2, SUM(c3) AS c3

FROM tsql_test_hanglietongji

GROUP BY c1, c2

union all

SELECT c1, nvl(null, ‘total‘) AS c2, SUM(c3) AS c3

FROM tsql_test_hanglietongji

GROUP BY c1

union all

SELECT NULL, ‘total‘ AS c2, SUM(c3) AS c3

FROM tsql_test_hanglietongji

order by 1, 2

细心的朋友也许注意到了，第二个union all带了order by 1,2而上面的mysql没有带order by,这和mysql和oracle对NULL的默认排序规则有关。

使用普通sql重写rollup为：

SELECT nvl(c1, ‘total‘) AS total_c,

SUM(decode(c2, ‘B1‘, c3, 0)) AS B1,

SUM(decode(c2, ‘B2‘, c3, 0)) AS B2,

SUM(decode(c2, ‘B3‘, c3, 0)) AS B3,

SUM(decode(c2, ‘B4‘, c3, 0)) AS B4,

SUM(decode(c2, ‘total‘, c3, 0)) AS total_r

FROM (SELECT c1, nvl(c2, ‘total‘) AS c2, SUM(c3) AS c3

FROM tsql_test_hanglietongji

GROUP BY c1, c2

HAVING c1 IS NOT NULL

union all

SELECT c1, nvl(null, ‘total‘) AS c2, SUM(c3) AS c3

FROM tsql_test_hanglietongji

GROUP BY c1

HAVING c1 IS NOT NULL) A

GROUP BY c1

union all

SELECT nvl(null, ‘total‘) AS total_c,

SUM(decode(c2, ‘B1‘, c3, 0)) AS B1,

SUM(decode(c2, ‘B2‘, c3, 0)) AS B2,

SUM(decode(c2, ‘B3‘, c3, 0)) AS B3,

SUM(decode(c2, ‘B4‘, c3, 0)) AS B4,

SUM(decode(c2, ‘total‘, c3, 0)) AS total_r

FROM (SELECT c1, nvl(c2, ‘total‘) AS c2, SUM(c3) AS c3

FROM tsql_test_hanglietongji

GROUP BY c1, c2

HAVING c1 IS NOT NULL

union all

SELECT c1, nvl(null, ‘total‘) AS c2, SUM(c3) AS c3

FROM tsql_test_hanglietongji

GROUP BY c1

HAVING c1 IS NOT NULL) A

order by 1

这里也排除了c1 is null的情况。

通过上面的对比，发现oracle和mysql的rollup非常相似，对rollup函数感兴趣的朋友请仔细搜索rollup学习。

到这里该结束了，有任何意见请留言，如文中sql有错误也请指出，谢谢。

时间： 11-20

吴钧泽
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle分组函数之ROLLUP的基本用法
09-09
主要给大家介绍了关于Oracle分组函数之ROLLUP的基本用法，文中通过示例代码介绍的非常详细，对大家学习或者使用Oracle数据库具有一定的参考学习价值，需要的朋友们下面来一起学习学习吧
grouping函数 mysql_ORACLE GROUPING函数的使用
weixin_31429257的博客
03-06 383
ORACLE GROUPING函数的使用GROUPING函数可以接受一列，返回0或者1。如果列值为空，那么GROUPING()返回1；如果列值非空，那么返回0。GROUPING只能在使用ROLLUP或CUBE的查询中使用。当需要在返回空值的地方显示某个值时，GROUPING()就非常有用。关于ROLLUP和CUBE函数的使用，请参见我的另一篇文章。http://blog.csdn.net/wh62...
Oracle的一些语句 转换为Mysql如何写
AiCx_1215的博客
01-04 924
1. 创建一个表 （涉及，数据类型，默认值，非空） 1.1Qracle建表 CREATE TABLE employee( id NUMBER(4), name VARCHAR2(20) NOT NULL, gender CHAR(1) DEFAULT 'M', birth DATE, salary NUMBER(6,2) DEFAULT 5000, job VARCHAR2(30) DEFAULT 'CLERK', deptno NUMBER(2) ); 1.2Mysql建表 CREATE
oracle中rollup函数与mysql中with rollup区别
kang1011的博客
07-26 1738
oracle中rollup函数与mysql中with rollup区别 1：oracle中rollup函数 对查询列 进行汇总计算后的结果。 用法：通常用于合计 SELECT l.id,count(*) FROM emp l group by rollup(l.id); http://blog.itpub.net/519536/viewspace-610995 2：mysql中with rollup 也是对结果列进行合并计算 用法 SELECT l.id,count(*) FROM emp
mysql with rollup_MySQL-with rollup函数运用
weixin_29149577的博客
01-18 646
如果想在下面这个表下面添加一行 总计 数据行SQL代码怎么实现 并且根据9月金额进行城市降序 总计置于底部呢MySQL提供了 group by with rollup 函数进行group by 字段的汇总但是order by 互斥的不能同时用第一步还是是先计算各城市每个月的金额SELECT b.城市,SUM(IF(b.年月=201607,b.金额,NULL)) AS 7月金额,SUM(IF(b.年...
MySQL笔试题一条语句解决问题多表联查聚合查询
03-16
这些问题不仅适用于MySQL，也可以推广到其他类似的关系型数据库，如Oracle、DB2等。 ### 题目1 #### 问题1.1 为了查询第一季度各类型的记录数累计值，我们需要计算每个类型在2023年1月1日至3月31日之间的记录数量...
mysql-5.7.17.msi安装版
10-11
5. **SQL 功能扩展**：增加了窗口函数、GROUP BY with ROLLUP 和 CUBE 功能，以及用户定义变量的增强，提升了 SQL 编程的灵活性和功能性。 6. **复制改进**：改进了复制功能，包括GTID（全局事务标识符）的默认启用...
处理group by 查询速度太慢的问题 数据量大.doc
12-18
优化 Group By 查询速度的...通过本实例，我们可以总结出一些有价值的经验：在优化 Group By 查询时，需要将聚合函数用到的字段一起设置为联合索引；需要充分测试和分析查询结果；需要遵循一定的思路来优化查询；等等。
数据库复习题2(答案)复习进程.pdf
06-06
常见的 DBMS 有 Oracle、MySQL、Microsoft SQL Server 等。 5. 查询语言 查询语言是指用于检索和操作数据库的语言。常见的查询语言有 SQL、QL 等。SQL 是一种标准的查询语言，用于管理关系数据库。 6. 数据库安全...
sql-challenge:SQL挑战
03-05
此外，你还需要熟悉特定数据库系统的特性，如MySQL、Oracle、SQL Server或PostgreSQL的特有功能。每个系统可能在语法上略有差异，但基本概念是通用的。 通过参与"SQL挑战"，你不仅可以提高SQL编程技能，还能锻炼...
group by后使用rollup子句总结
10-14
group by后使用rollup子句总结，oracle开发人员值得一看
Sql学习第四天——SQL 关于with cube,with rollup和grouping解释及演示
12-15
关于with cube ，with rollup 和 grouping 通过查看sql 2005的帮助文档找到了CUBE 和 ROLLUP 之间的具体区别： CUBE 生成的结果集显示了所选列中值的所有组合的聚合。ROLLUP 生成的结果集显示了所选列中值的某一层次结构的聚合。 再看看对grouping的解释： 当行由 CUBE 或 ROLLUP 运算符添加时，该函数将导致附加列的输出值为 1；当行不由 CUBE 或 ROLLUP 运算符添加时，该函数将导致附加列的输出值为 0。 仅在与包含 CUBE 或 ROLLUP 运算符的 GROUP BY 子句相关联的选择列表中才允许分组。 当看到以上
MySQL 中with rollup的用法，对分组再汇总
无知是恶
08-17 1570
rollup 主要作用: 对group by分组的结果再进行汇总举例： 运行不带with rollup 运行带with rollup 最后会多一条结果，就是对分组聚合结果的汇总待补充 grouping_sets，cube
mysql group rollup_MySQL 聚合函数（二）Group By的修饰符——ROLLUP
weixin_42423817的博客
01-19 443
一、ROLLUP 修饰符的意义GROUP BY子句允许添加WITH ROLLUP修饰符，该修饰符可以对分组后各组的某个列的结果值进行汇总，并在结果中输出，即提供更高一级的聚合操作。因此，ROLLUP使您能够使用单个查询在多个分析级别回答问题。例如，ROLLUP可用于为OLAP(在线分析处理)操作提供支持。现在有一个示例销售表如下：CREATE TABLEsales(year INT,coun...
oralce rollup 小计合计_总计与小计–WITH ROLLUP
weixin_35045973的博客
01-14 1216
rollup:汇总在GROUP后加WITH ROLLUP来实现总计与小计，它会对每次分组的结果进行ROLLUP操作，产生汇总的结果，显示在行下。在显示的时候可用GROUPING来判断当天是数据行还是汇总行，GROUPING为1时是汇总行，为0为数据行。1，当GROUP只有一个字段时，ROLLUP在最后一行会显示总计2，当GROUP有多个字段时，在上一个字段改变时显示汇总结果即：ROLLUP会在上个...
WITH ROLLUP的简单使用
最新发布
tiantiantbtb的博客
02-03 187
mysql rollup语法_SQL Rollup
weixin_32158567的博客
02-10 3167
在本教程中，您将学习如何使用SQL ROLLUP生成多个分组集。1. SQL ROLLUP简介ROLLUP是GROUP BY子句的扩展。 ROLLUP选项允许包含表示小计的额外行，通常称为超级聚合行，以及总计行。 通过使用ROLLUP选项，可以使用单个查询生成多个分组集。注意，分组集是一组用于分组的列。 例如，一个由仓库返回库存的查询，分组集是(warehouse)。SELECTwarehouse...
oracle 中 group by rollup(id)与mysql 的 group by with rollup id
kang1011的博客
05-30 643
1:rollup: group by 后可以跟 rollup，表示在进行分组统计的基础上再次进行汇总统计（在每个分组下都会有统计汇总） 2:oracle 中 group by rollup(id) group by后带rollup子句所返回的结果集，可以理解为各个分组所产生的结果集的并集且没有去掉重复数据。 Group by rollup(A ,B) 产生的分组种数：3种； 第一种：group by A,B 第二种：group by A 第三种：group by NULL 结果集条数=a*b+a+
mysql rollup函数
08-18
下面是一个示例，演示如何在 MySQL 中使用 ROLLUP 函数： ```sql SELECT column1, column2, SUM(column3) AS total FROM table_name GROUP BY column1, column2 WITH ROLLUP; ``` 在上面的示例中，`column1` 和 `...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值