mysql 分组查询数据

    今天项目BOSS提了个sql语句需求，我听得稀里糊涂，没办法，一步步讨论、实践，最终搞定。

    先上建表语句：

 1 /* 2 Navicat MySQL Data Transfer 3  4 Source Server     : localhost_3306 5 Source Server Version : 50623 6 Source Host      : localhost:3306 7 Source Database    : demo 8  9 Target Server Type  : MYSQL10 Target Server Version : 5062311 File Encoding     : 6500112 13 Date: 2015-08-16 00:02:2214 */15 16 SET FOREIGN_KEY_CHECKS=0;17 18 -- ----------------------------19 -- Table structure for t_info20 -- ----------------------------21 DROP TABLE IF EXISTS `t_info`;22 CREATE TABLE `t_info` (23  `id` int(11) NOT NULL AUTO_INCREMENT,24  `name` varchar(24) DEFAULT NULL,25  `number` int(11) DEFAULT NULL,26  PRIMARY KEY (`id`)27 ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;28 29 -- ----------------------------30 -- Records of t_info31 -- ----------------------------32 INSERT INTO `t_info` VALUES ('1', 'a', '18');33 INSERT INTO `t_info` VALUES ('2', 'b', '18');34 INSERT INTO `t_info` VALUES ('3', 'a', '17');35 INSERT INTO `t_info` VALUES ('4', 'a', '19');36 INSERT INTO `t_info` VALUES ('5', 'a', '20');37 INSERT INTO `t_info` VALUES ('6', 'b', '30');38 INSERT INTO `t_info` VALUES ('7', 'b', '31');39 INSERT INTO `t_info` VALUES ('8', 'b', '32');40 INSERT INTO `t_info` VALUES ('9', 'a', '25');41 INSERT INTO `t_info` VALUES ('10', 'b', '26');

海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理：https://www.xlkjsw.com

原标题：mysql 分组查询数据

关键词：MYSQL