mysql,5.1,有如下sql语句,
-- ----------------------------
-- Table structure for `ppmytj`
-- ----------------------------
DROP TABLE IF EXISTS `ppmytj`;
CREATE TABLE `ppmytj` (
`id` int(11) NOT NULL auto_increment,
`ques` varchar(255) NOT NULL,
`typename` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=100 DEFAULT CHARSET=gbk;-- ----------------------------
-- Records of ppmytj
-- ----------------------------
INSERT INTO `ppmytj` VALUES ('31', '点石家装', 'decorationcompany');
INSERT INTO `ppmytj` VALUES ('32', '宇杰装饰', 'decorationcompany');
INSERT INTO `ppmytj` VALUES ('33', '鼎佳装饰', 'decorationcompany');
INSERT INTO `ppmytj` VALUES ('34', '马可波罗瓷砖', 'stone');
INSERT INTO `ppmytj` VALUES ('35', '宏陶陶瓷', 'stone');
INSERT INTO `ppmytj` VALUES ('36', '菲林格尔', 'floors');
INSERT INTO `ppmytj` VALUES ('37', '马克森地板', 'floors');
INSERT INTO `ppmytj` VALUES ('38', '三星地板', 'floors');
INSERT INTO `ppmytj` VALUES ('39', '法瑞集成环保灶', 'kitchen');
INSERT INTO `ppmytj` VALUES ('40', '老板电器', 'kitchen');
INSERT INTO `ppmytj` VALUES ('41', '方太电器', 'kitchen');
INSERT INTO `ppmytj` VALUES ('42', '尚高卫浴', 'bathroom');
INSERT INTO `ppmytj` VALUES ('43', '九牧卫浴', 'bathroom');
INSERT INTO `ppmytj` VALUES ('44', '奥特朗电热水器', 'bathroom');
INSERT INTO `ppmytj` VALUES ('45', '宝兰吊顶', 'ceilings');
INSERT INTO `ppmytj` VALUES ('46', '楚楚吊顶', 'ceilings');
INSERT INTO `ppmytj` VALUES ('47', '扬子集成吊顶', 'ceilings');
INSERT INTO `ppmytj` VALUES ('48', '绿娃门窗', 'doorwindow');
INSERT INTO `ppmytj` VALUES ('49', '欧派木门', 'doorwindow');
INSERT INTO `ppmytj` VALUES ('50', '盼盼安居门', 'doorwindow');
INSERT INTO `ppmytj` VALUES ('51', '马克森衣柜', 'furniture');
INSERT INTO `ppmytj` VALUES ('52', '九鑫家俬', 'furniture');
INSERT INTO `ppmytj` VALUES ('53', '巨桑家私', 'furniture');
INSERT INTO `ppmytj` VALUES ('54', '欧特朗照明', 'buildingmaterials');
INSERT INTO `ppmytj` VALUES ('55', '朗斯地暖', 'buildingmaterials');
INSERT INTO `ppmytj` VALUES ('56', '欧雅壁纸', 'decoration');
INSERT INTO `ppmytj` VALUES ('57', '瑞丽布艺', 'decoration');
INSERT INTO `ppmytj` VALUES ('58', '青花瓷墙纸', 'decoration');
INSERT INTO `ppmytj` VALUES ('59', '宏图三胞', 'appliancestores');
INSERT INTO `ppmytj` VALUES ('60', '商之都.国生电器', 'appliancestores');
INSERT INTO `ppmytj` VALUES ('61', '壹品装饰', 'decorationcompany');
INSERT INTO `ppmytj` VALUES ('62', '喜来登装饰', 'decorationcompany');
INSERT INTO `ppmytj` VALUES ('63', '光明美家', 'decorationcompany');
INSERT INTO `ppmytj` VALUES ('64', '金舵陶瓷', 'stone');
INSERT INTO `ppmytj` VALUES ('65', '诺贝尔瓷砖', 'stone');
INSERT INTO `ppmytj` VALUES ('66', '百得防水', 'stone');
INSERT INTO `ppmytj` VALUES ('67', '冠珠陶瓷', 'stone');
INSERT INTO `ppmytj` VALUES ('68', '大自然地板', 'floors');
INSERT INTO `ppmytj` VALUES ('69', '兔宝宝板材', 'floors');
INSERT INTO `ppmytj` VALUES ('70', '世友地板', 'floors');
INSERT INTO `ppmytj` VALUES ('71', '法瑞集成环保灶', 'kitchen');
INSERT INTO `ppmytj` VALUES ('72', '志邦厨柜', 'kitchen');
INSERT INTO `ppmytj` VALUES ('73', '康佳厨卫电器', 'kitchen');
INSERT INTO `ppmytj` VALUES ('74', '桑夏太阳能', 'bathroom');
INSERT INTO `ppmytj` VALUES ('75', '华帝太阳能', 'bathroom');
INSERT INTO `ppmytj` VALUES ('76', '皇明太阳能', 'bathroom');
INSERT INTO `ppmytj` VALUES ('77', '德国欧卫集成吊顶', 'ceilings');
INSERT INTO `ppmytj` VALUES ('78', '扬子集成吊顶', 'ceilings');
INSERT INTO `ppmytj` VALUES ('79', '友邦集成吊顶', 'ceilings');
INSERT INTO `ppmytj` VALUES ('80', '合室家室内门', 'doorwindow');
INSERT INTO `ppmytj` VALUES ('81', '大洋豪门', 'doorwindow');
INSERT INTO `ppmytj` VALUES ('82', '扬金移门', 'doorwindow');
INSERT INTO `ppmytj` VALUES ('83', '美蒂娅移门整体衣柜', 'furniture');
INSERT INTO `ppmytj` VALUES ('84', '巨桑家私', 'furniture');
INSERT INTO `ppmytj` VALUES ('85', '喜临门法诗曼床垫', 'furniture');
INSERT INTO `ppmytj` VALUES ('86', '嘉美照明', 'buildingmaterials');
INSERT INTO `ppmytj` VALUES ('87', '欧特朗照明', 'buildingmaterials');
INSERT INTO `ppmytj` VALUES ('88', '瑞斯博地暖', 'buildingmaterials');
INSERT INTO `ppmytj` VALUES ('89', '爵迈墙纸', 'decoration');
INSERT INTO `ppmytj` VALUES ('90', '装饰家漆', 'decoration');
INSERT INTO `ppmytj` VALUES ('91', '多乐士漆', 'decoration');
INSERT INTO `ppmytj` VALUES ('92', '华海3C数码广场', 'appliancestores');
INSERT INTO `ppmytj` VALUES ('93', '商之都.国生电器', 'appliancestores');
INSERT INTO `ppmytj` VALUES ('94', '五星电器', 'appliancestores');需要统计出这样的结果,在typename值相同的情况下,统计每个ques列的值出现的次数
例如
ques num typename
点石家装 3 decorationcompany
宇杰装饰 4 decorationcompany
鼎佳装饰 1 decorationcompany这是一个投票结果的表
-- ----------------------------
-- Table structure for `ppmytj`
-- ----------------------------
DROP TABLE IF EXISTS `ppmytj`;
CREATE TABLE `ppmytj` (
`id` int(11) NOT NULL auto_increment,
`ques` varchar(255) NOT NULL,
`typename` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=100 DEFAULT CHARSET=gbk;-- ----------------------------
-- Records of ppmytj
-- ----------------------------
INSERT INTO `ppmytj` VALUES ('31', '点石家装', 'decorationcompany');
INSERT INTO `ppmytj` VALUES ('32', '宇杰装饰', 'decorationcompany');
INSERT INTO `ppmytj` VALUES ('33', '鼎佳装饰', 'decorationcompany');
INSERT INTO `ppmytj` VALUES ('34', '马可波罗瓷砖', 'stone');
INSERT INTO `ppmytj` VALUES ('35', '宏陶陶瓷', 'stone');
INSERT INTO `ppmytj` VALUES ('36', '菲林格尔', 'floors');
INSERT INTO `ppmytj` VALUES ('37', '马克森地板', 'floors');
INSERT INTO `ppmytj` VALUES ('38', '三星地板', 'floors');
INSERT INTO `ppmytj` VALUES ('39', '法瑞集成环保灶', 'kitchen');
INSERT INTO `ppmytj` VALUES ('40', '老板电器', 'kitchen');
INSERT INTO `ppmytj` VALUES ('41', '方太电器', 'kitchen');
INSERT INTO `ppmytj` VALUES ('42', '尚高卫浴', 'bathroom');
INSERT INTO `ppmytj` VALUES ('43', '九牧卫浴', 'bathroom');
INSERT INTO `ppmytj` VALUES ('44', '奥特朗电热水器', 'bathroom');
INSERT INTO `ppmytj` VALUES ('45', '宝兰吊顶', 'ceilings');
INSERT INTO `ppmytj` VALUES ('46', '楚楚吊顶', 'ceilings');
INSERT INTO `ppmytj` VALUES ('47', '扬子集成吊顶', 'ceilings');
INSERT INTO `ppmytj` VALUES ('48', '绿娃门窗', 'doorwindow');
INSERT INTO `ppmytj` VALUES ('49', '欧派木门', 'doorwindow');
INSERT INTO `ppmytj` VALUES ('50', '盼盼安居门', 'doorwindow');
INSERT INTO `ppmytj` VALUES ('51', '马克森衣柜', 'furniture');
INSERT INTO `ppmytj` VALUES ('52', '九鑫家俬', 'furniture');
INSERT INTO `ppmytj` VALUES ('53', '巨桑家私', 'furniture');
INSERT INTO `ppmytj` VALUES ('54', '欧特朗照明', 'buildingmaterials');
INSERT INTO `ppmytj` VALUES ('55', '朗斯地暖', 'buildingmaterials');
INSERT INTO `ppmytj` VALUES ('56', '欧雅壁纸', 'decoration');
INSERT INTO `ppmytj` VALUES ('57', '瑞丽布艺', 'decoration');
INSERT INTO `ppmytj` VALUES ('58', '青花瓷墙纸', 'decoration');
INSERT INTO `ppmytj` VALUES ('59', '宏图三胞', 'appliancestores');
INSERT INTO `ppmytj` VALUES ('60', '商之都.国生电器', 'appliancestores');
INSERT INTO `ppmytj` VALUES ('61', '壹品装饰', 'decorationcompany');
INSERT INTO `ppmytj` VALUES ('62', '喜来登装饰', 'decorationcompany');
INSERT INTO `ppmytj` VALUES ('63', '光明美家', 'decorationcompany');
INSERT INTO `ppmytj` VALUES ('64', '金舵陶瓷', 'stone');
INSERT INTO `ppmytj` VALUES ('65', '诺贝尔瓷砖', 'stone');
INSERT INTO `ppmytj` VALUES ('66', '百得防水', 'stone');
INSERT INTO `ppmytj` VALUES ('67', '冠珠陶瓷', 'stone');
INSERT INTO `ppmytj` VALUES ('68', '大自然地板', 'floors');
INSERT INTO `ppmytj` VALUES ('69', '兔宝宝板材', 'floors');
INSERT INTO `ppmytj` VALUES ('70', '世友地板', 'floors');
INSERT INTO `ppmytj` VALUES ('71', '法瑞集成环保灶', 'kitchen');
INSERT INTO `ppmytj` VALUES ('72', '志邦厨柜', 'kitchen');
INSERT INTO `ppmytj` VALUES ('73', '康佳厨卫电器', 'kitchen');
INSERT INTO `ppmytj` VALUES ('74', '桑夏太阳能', 'bathroom');
INSERT INTO `ppmytj` VALUES ('75', '华帝太阳能', 'bathroom');
INSERT INTO `ppmytj` VALUES ('76', '皇明太阳能', 'bathroom');
INSERT INTO `ppmytj` VALUES ('77', '德国欧卫集成吊顶', 'ceilings');
INSERT INTO `ppmytj` VALUES ('78', '扬子集成吊顶', 'ceilings');
INSERT INTO `ppmytj` VALUES ('79', '友邦集成吊顶', 'ceilings');
INSERT INTO `ppmytj` VALUES ('80', '合室家室内门', 'doorwindow');
INSERT INTO `ppmytj` VALUES ('81', '大洋豪门', 'doorwindow');
INSERT INTO `ppmytj` VALUES ('82', '扬金移门', 'doorwindow');
INSERT INTO `ppmytj` VALUES ('83', '美蒂娅移门整体衣柜', 'furniture');
INSERT INTO `ppmytj` VALUES ('84', '巨桑家私', 'furniture');
INSERT INTO `ppmytj` VALUES ('85', '喜临门法诗曼床垫', 'furniture');
INSERT INTO `ppmytj` VALUES ('86', '嘉美照明', 'buildingmaterials');
INSERT INTO `ppmytj` VALUES ('87', '欧特朗照明', 'buildingmaterials');
INSERT INTO `ppmytj` VALUES ('88', '瑞斯博地暖', 'buildingmaterials');
INSERT INTO `ppmytj` VALUES ('89', '爵迈墙纸', 'decoration');
INSERT INTO `ppmytj` VALUES ('90', '装饰家漆', 'decoration');
INSERT INTO `ppmytj` VALUES ('91', '多乐士漆', 'decoration');
INSERT INTO `ppmytj` VALUES ('92', '华海3C数码广场', 'appliancestores');
INSERT INTO `ppmytj` VALUES ('93', '商之都.国生电器', 'appliancestores');
INSERT INTO `ppmytj` VALUES ('94', '五星电器', 'appliancestores');需要统计出这样的结果,在typename值相同的情况下,统计每个ques列的值出现的次数
例如
ques num typename
点石家装 3 decorationcompany
宇杰装饰 4 decorationcompany
鼎佳装饰 1 decorationcompany这是一个投票结果的表
解决方案 »
- 谁能告诉我在存储过程中怎么建立视图呢?
- 关于mysql数据库Transfer的疑问
- hibernate不能创建MYSQL数据库
- 覆盖 database后,有ibdata,ib_logfile文件,怎么恢复
- mysql数据库中怎样实现,若表中不存在某个字段,就添加一个字段?
- 日期函数
- 请教一个MySQL跨表查询语句(突然想不起来了)
- 在sql语句中含有汉字,为什么查不出结果,怎么解决?在线等,谢谢了
- 比尔盖茨死了!!!!!!
- mysql按年、月分开的统计sql语句如何写
- 不显示删除回复显示所有回复显示星级回复显示得分回复 ==============如何写这样的Sql语句===================
- 表坏了 修复不好
点石家装 3 decorationcompany
是怎样得出的SELECT A.`typename`,QUES,COUNT(*) FROM `ppmytj` A GROUP BY A.`typename`,QUES;
部分结果:
appliancestores 宏图三胞 1
appliancestores 华海3C数码广场 1
appliancestores 商之都.国生电器 2
appliancestores 五星电器 1
bathroom 奥特朗电热水器 1
bathroom 华帝太阳能 1
bathroom 皇明太阳能 1
bathroom 九牧卫浴 1
bathroom 桑夏太阳能 1
bathroom 尚高卫浴 1
点石家装 3 decorationcompany这个3是怎么算出来的?