MySQL:
统计人数最多的部门
CREATE TABLE `people` (
`dept` int(11) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of people
-- ----------------------------
INSERT INTO `people` VALUES ('1', '12', 'we');
INSERT INTO `people` VALUES ('2', '23', 'sded');
INSERT INTO `people` VALUES ('1', '343', '34');
INSERT INTO `people` VALUES ('3', '34', '54');
SELECT dept,count(dept) a FROM people GROUP BY dept ORDER BY a desc LIMIT 1
例如,数据库某表有百万条数据
获取数据库某表中最后十条数据http://www.php.cn/mysql